This project has moved and is read-only. For the latest updates, please go here.

SSIS OLE DB Source - SQL command from variable

Jun 8, 2010 at 6:25 AM

I have a lot of SSIS packages where the OLE DB Source objects use the "SQL Command from variable" setting.  This is usually because parameters need to be fed into an Oracle query.  It looks like the Dependancy Analyzer tool misses these queries.  Can they be included please?

This looks like it could be a very interesting and useful tool.  Setup and execution went smoothly in my environment (SQL 2005 SP3 server, Win XP SP3 desktop).  Thanks for your efforts to-date.


Jun 8, 2010 at 7:23 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Jun 17, 2010 at 9:07 AM

Alpha 8, now available for download, handles this scenario.