|
|
Browse by Tags
All Tags » SSIS » SQL Server Inte... » Scripting » Expressions
-
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 ...
-
SQL Server Integration Services (SSIS) contains some really useful logging procedures but as with most things in SSIS, it is extensible. There are 2 methods of extending the logging capability of SSIS:
Build a custom log provider
Use event handlers
I am going to demonstrate the second of these methods - using SSIS event handlers to log to a ...
-
A common feature of DTS packages is that they can be dynamically edited at runtime. This is accomplished by using ActiveX script code to alter the DTS package which is in itself an instance of the DTS Object Model. Once you have access to that object model (which in script is done by using the line "DTSGlobalVarables.Parent") you can ...
|
|
|