posts - 10, comments - 49, trackbacks - 0

August 2008 Blog Posts

Using System Variables as Parameters in an OLE DB Source Query

You can expect: This is a low intensity post (you should be able to do this in your sleep). I Expect (that you have the following experience): Simple SSIS Dataflow work   OLE DB Source Queries with Parameters The OLE DB  Source allows you to enter a Select statement to retrieve data from a source.  As I stated several times before, this is the preferred method.  If you want to use parameters, this is the ONLY method you can use.  It is fairly easy to use parameters.  You just use a ? for each parameter you wish to map.  Then you click...

posted @ Wednesday, August 20, 2008 9:31 AM | Feedback (10) | Filed Under [ SSIS Madness ]

Powered by:
Powered By Subtext Powered By ASP.NET