Post reply

Need some helps

  • April 16, 2014 at 10:08 am

    #284668

    Hi All,

    I have two text files named Jan2014_Sales.txt, and Feb2014_Sales.txt with some data. I need to create a output file named Jan2014_Feb2014_Sales. I can easily use the data flow task inside the For Each Loop task and combine the data but How can I concanate source files?

    Thanks,

    Ganesh

  • April 16, 2014 at 10:28 am

    #1706532

    You can use two variables, one to store the current file name and to concatenate the file name. The way you do it is using an expression builder to the second variable to add the new file name every time it goes into the loop.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

Viewing 2 posts - 1 through 1 (of 1 total)

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