Post reply

How to copy new file dropped in the folder using SSIS

  • August 30, 2010 at 11:55 am

    #141774

    Hi

    I need a help in creating a package which will copy new file dropped in the folder using SSIS. Folder will have textfiles for eg: abc_26-08-2010_27-08-2010,

    abc_27-08-2010_28-08-2010. Please help me to achieve this.

    Thanks in advance

  • August 31, 2010 at 10:18 am

    #1214458

    This looks like it is fairly simple to do in SSIS.

    Honestly, it looks like you're trying to use SSIS before taking the time to learn how to do things in SSIS.

    What have you tried so far? Are you getting any errors or incorrect results?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 31, 2010 at 10:19 am

    #1214460

    What do you mean by "copy?" File copy, copy data to new file or to database?

    Russel Loski, MCSE Business Intelligence, Data Platform

  • September 2, 2010 at 4:42 pm

    #1215982

    Sql_20 (8/30/2010)

    Hi

    I need a help in creating a package which will copy new file dropped in the folder using SSIS. Folder will have textfiles for eg: abc_26-08-2010_27-08-2010,

    abc_27-08-2010_28-08-2010. Please help me to achieve this.

    Thanks in advance

    Use Foreach loop ..in that use the flatfile enumarator to loop through all the text files and do the required operation. i.e copy to a new location or Load the data into a database table

  • September 6, 2010 at 5:58 am

    #1216892

    Alvin Ramard (8/31/2010)

    This looks like it is fairly simple to do in SSIS.

    Honestly, it looks like you're trying to use SSIS before taking the time to learn how to do things in SSIS.

    What have you tried so far? Are you getting any errors or incorrect results?

    Let us complicate the scenario...

    I belive that a WMI Event watcher will be used in compliment with WMI data reader...

    which will then trigger FST

    Raunak J

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply