Home Forums SQL Server 2005 Business Intelligence SSIS-Data in multiple .csv files to columns in same csv file RE: SSIS-Data in multiple .csv files to columns in same csv file

  • April 25, 2013 at 6:23 am

    #1609900

    avinash.818 (4/25/2013)

    Hi Everyone

    I have the below problem,could anyone please suggest me a solution.

    file 1 has below data

    1.csv

    A

    B

    C

    2.csv

    E

    F

    G

    the data in the output file should be

    A E

    B F

    C G

    the separator in output file can be tab or ,

    could any one help?

    Use a Data Flow task with a MERGE connector to pull the files into the same data stream. Then output to a new file.

    That's the best advice I can give you based on the information you've provided.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.