Update table using Raw file source in SSIS
-
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
-
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply