Monday, August 31, 2015

How can a “Data driven query” task from DTS be implemented using the SSIS transform objects?


One way to implement this functionality is to use a lookup component to determine if certain data exists (the select query of DDQ), then to redirect rowsets based on failure (data does not exist) or success (data does exist) of the lookup component to the appropriate data operation (insert/update/etc.).

No comments:

Post a Comment