Need some helps

  • 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

  • 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