locked
how to load csv file data into single column single row of a table using ssis? RRS feed

  • Question

  • hi ,

    i am new to ssis , i got one requirement like

    1. client will give one csv file to us which contains 100 rows 100 columns.

    2. my requirement is : i need to store the above csv file data into single colum , single row of a table.

    4. my table sample structure is :

    id                               date

    --                                ---

    Note: id column data type is Unique identifier and  date column data type is varbinary(max).

    my sample csv file is:

    Mdate,bdate,login,name

    2012-12-12,2012-112-12,\\localhost\name\sada

    2012-12-12,2012-112-12,\\localhost\name\sada

    Expected output:

    id                               date

    1                    the above csv file should load as single row









    franklinsentil

    Monday, February 25, 2013 3:21 PM

Answers

  • Hi Rajkumar,
    I guess there is no issue


    Please mark my post as Answer or as Helpful if it helps you

    • Marked as answer by Eileen Zhao Tuesday, March 5, 2013 5:58 AM
    Tuesday, February 26, 2013 7:36 AM

All replies

  • Hello,

    You can use the Import Column data transformation task in SSIS.

    Monday, February 25, 2013 3:30 PM
  • You can make your Flat File Data Source set as one column (that is to read this input file as having kist one column, no column delimiters) and then you simply insert the column data into the table using OLEDB Destination,

    example:

    http://bit.ly/WehiKT


    Arthur My Blog

    Monday, February 25, 2013 3:41 PM
  • Hi ,

    already i did the same task ,1. flat file source

    2. oledb destination

    finally i loaded data into single column but multiple rows are there. so i need to keep all rows into single cell value


    franklinsentil

    Monday, February 25, 2013 5:38 PM
  • Do as Mayorlag suggested - use the Import Column data flow component.

    Todd McDermid's Blog Talk to me now on

    Monday, February 25, 2013 7:23 PM
  • hi,

    Import column usefult to us when ever we need to import images.

    i tried it, i failed


    franklinsentil

    Tuesday, February 26, 2013 3:10 AM
  • Would you like help using it?  If yes, please let us know more.

    Todd McDermid's Blog Talk to me now on

    Tuesday, February 26, 2013 3:48 AM
  • Hi FranklinSentil,
    Your issue can be easily solved by proper configuration of Flat File Connection Manager

    You should change "Column delimiter" from automatically assign value to any kind of values and press Refresh button


    Please mark my post as Answer or as Helpful if it helps you

    Tuesday, February 26, 2013 6:46 AM
  • Modification, which should be done


    Please mark my post as Answer or as Helpful if it helps you


    Tuesday, February 26, 2013 6:47 AM

  • Please mark my post as Answer or as Helpful if it helps you

    • Proposed as answer by ArthurZ Wednesday, February 27, 2013 2:49 AM
    Tuesday, February 26, 2013 6:52 AM
  • How about configuring the source connection manager with one column of data type Text or NText and mapping it with a Text column in Destination Table..

    Rajkumar

    Tuesday, February 26, 2013 7:07 AM
  • Hi Rajkumar,
    I guess there is no issue


    Please mark my post as Answer or as Helpful if it helps you

    • Marked as answer by Eileen Zhao Tuesday, March 5, 2013 5:58 AM
    Tuesday, February 26, 2013 7:36 AM
  • How about configuring the source connection manager with one column of data type Text or NText and mapping it with a Text column in Destination Table..

    Rajkumar


    That's my thinking, too. The examples provided by Kostya must be of help.

    Arthur My Blog

    Wednesday, February 27, 2013 2:49 AM