sql server dts: Does anyone know or can provide an example of how to use
SQLSourceType: Variable in Execute SQL Task Editor

and

SQL command from variable in OLE DB Source Editor?

Hi

You have to create a string variable that is visible from the data flow.
Then you choose the variable and then the OLEDB SOURCE will use the query
that you specify in the variable.
I.E. set the string variable to select * from "yourtable" and click preview.

cheers

--

Francisco A. Gonzalez
fgonzalez@solidq.com



[quoted text, click to view]