I am using OLE DB data source component as a part of data flow task, but I would like to keep the sql query in an external file and not embedded in the task itself. Is there an easy way to accomplish this?
views:
27answers:
1
+1
A:
You could use a script task in your control flow to extract the sql query from the file and store it in a string variable. You could then use the variable as a source for you ole db data source component.
rfonn
2010-01-21 17:43:38