Post reply

truncate headers in a csv

  • October 30, 2009 at 11:18 am

    #137044

    Hi All,

    I have a text in the following format

    Row1: ABC Company

    Row2: Address

    Row3 (Column Names): Cust_Id Cust_Name

    Row4 (Actual Row) : 123 Ndaves

    Row5: ABC Company

    Row6: Address

    Row7 (Column Names): Cust_Id Cust_Name

    Row8 (Actual Row) : 456 Kjorge

    I have to create a ssis package to load this into SQL table.

    Please suggest how this can be done.

    Thanks,

  • October 30, 2009 at 2:33 pm

    #1073380

    Hi,

    You may need to use the script component to read the data and load a dataflow with it. You'll most likeley use the .NET streamreader object to get the data from the text file.

    Thanks,

    Strick

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

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