|
|
Browse by Tags
All Tags » SSIS » best practice » ole db source adapter
-
I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...
-
I reckon that one of the most commonly used components in SSIS is the OLE DB Source component. This is the one that you use to pick up data from an OLE DB compliant data source (e.g. a database) in order to use that data in your pipeline. This is done with a SQL statement.
One of the more common usage scenarios is to dynamically ...
|
|
|