Post reply

SSIS

  • March 25, 2009 at 2:07 am

    #201586

    Hello all,

    I'm newbie in SSIS. I'm looking to insert the data to the database through the flat file. would it be possible to insert data from multiple data sources to the same ole db destination.

    Anyone please clarify this.

    Thanks

    SP

  • March 25, 2009 at 2:54 am

    #965845

    Well nto sure if this helps, I have inserted several "Flat Files" into one "OLE DB". Each file will load into a differant table within the DB

    - You Need to create a "DataFlowTask".

    - Within this you can insert you "Flat Files"

    - Create a OLE DB Destination

    Option 1

    If you want to insert each flat file into a differant table, you will need to create a new OLE DB Destination for each flat file

    Option 2

    Point each file to the same OLE DB Destination.

    Not sure if you can do this as each insert may cause a lock on the table if you run it at the same time.

  • March 25, 2009 at 2:55 am

    #965846

    Well not sure if this helps, I have inserted several "Flat Files" into one "OLE DB". Each file will load into a differant table within the DB

    - You Need to create a "DataFlowTask".

    - Within this you can insert you "Flat Files"

    - Create a OLE DB Destination

    Option 1

    If you want to insert each flat file into a differant table, you will need to create a new OLE DB Destination for each flat file

    Option 2

    Point each file to the same OLE DB Destination.

    Not sure if you can do this as each insert may cause a lock on the table if you run it at the same time.

  • March 25, 2009 at 4:34 am

    #965878

    Hi,

    I attempt to insert both flat file source to the same table. I have done whatever you have told, its working. Each flat file contains 5 rows and columns.The first flat file inserts the record successfully whereas the second flat file inserts NULL value for the first column. I dont know what was happened. Could anyone help?

    Thanks

    Sashiprasanna

  • March 25, 2009 at 5:00 am

    #965888

    Hi,

    I ran the SSIS as per your suggestion. I used two flat files to insert the data to database. Each flat files contains 5 rows and columns. Insertion was successfully finished but NULL value's were inserted to the first field whereas rest of the columns were inserted correctly. Could anyone help me out from which flat file the NULL value is inserted?

    Thanks

    P Sashi

  • March 25, 2009 at 5:16 am

    #965891

    We would need more information.

    - Please give us some example data in the flat file, i.e. one of the rows being inserted.

    - What is the data type of the column in the database which is showing NULL

    - If you go into the DataFlow and open the "Flat File Source Editor" and select Preview, does the data look ok?

  • March 27, 2009 at 2:54 am

    #967251

    Thanks to help me find out!! Its working now.

Viewing 7 posts - 1 through 6 (of 6 total)

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