Home Forums Data Warehousing Integration Services .txt and .csv RE: .txt and .csv

  • May 3, 2013 at 5:51 am

    #1612162

    SQL_Learning (5/2/2013)

    Hi,

    I was trying to get all my .txt and .csv files from one folder and move them to another folder so, how can i do that in foreach loop container i tried *.* as i has some more file types it is selecting all of them i need only .csv and .txt files can any of you guys help me in this..

    I am assuming that you are doing other things with these file and not just moving them?

    If not, the FEL is overkill (and potentially slow). Instead you could use Execute Process to issue a DOS MOVE command. Or use a Script Task to do the same in C#.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.