My SqlComand on SSIS - DataFlow OLE DB Command seems not works

Answer 1

I think this is your scenario:

• You are extracting data from an OLEDB source which puts the data in a buffer.
• Next you process the contents of the buffer with an Aggregate component.
• After that, you run a Sql Command (which selects two constants from the database) which doesn't affect the buffer (or anything else).
• Finally, you send the output of the buffer into an OLEDB destination.

Instead of the SQL Command (which doesn't affect the buffer) you need to use a derived column to replace the value in the two columns that are null with the constant values you want in those columns.

To clarify, the SQL Command task is used to take information from your data flow and effect a change on an actual database. It is not used to gather information from your database to change data in your data flow.