Post reply

Update table using Raw file source in SSIS

  • September 14, 2011 at 2:48 pm

    #390408

    Hell guys..Is there a way to update the T-SQL table using RAW file source..currently I am using an OLEDB command which is very very slow..so what are the other options for this purpose..Thanks in advance 🙂

  • September 15, 2011 at 8:42 am

    #1382012

    SSIS is not designed for updating. It's designed for taking data and transforming it, then putting the results in a destination.

    If you really want to be doing the updates through SSIS, then yeah you'll need to use the OLE DB Command.

    An alternative would be to use a Data Flow Task to take the raw file, perform any transformations necessary, and then put the results into a table, then use a Execute SQL Task to take the results from that table and perform an update against your actual table, using a join to connect the relevant rows.

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

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