SQLTeam.com | Weblogs | Forums

Get SQL-Statement in DFT at Runtime

Is it possible to output the SQL statement (from Table/View or
DirectInput) at runtime from a Dataflow task (DataSource OLEDB)? (Maybe
via Script ...)

Hi, Yes you are on the right track. Not on the Dataflow but on the source or destination in a Dataflow Task. You could assign the value to a variable in a Script Task.
This should help you figure out how to code it. https://msdn.microsoft.com/en-us/library/ms135939.aspx