Anyone know why the Execute SQL Task is only available under Control flow and not Data flow? (At times it's a useful data manipuation task and I wish was available as a Data flow task as well.)
Barkingdog
It could lead to some extremely inefficient data flows.
Imagine executing a SQL statement for every record in a 1,000,000 row transformation?
Or what if you decided to execute an update against the source data in your transformation?
The posiibilities for abuse are staggering...
If you need to run a SQL task doing it before or after a transformation allows you to execute SQL on the entire set... Not just a single record.
|||ssis provides the ole db command data flow transformation component for sql-based data manipulation: http://msdn2.microsoft.com/en-us/library/ms141138.aspx