“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.).




keywords

SSIS interview questions,SSIS Interview Questions and Answers , SSIS interview Questions PDF Download , SSIS Interview Questions for Experienced.
2012 ssis interview questions.