Welcome to EMC Consulting Blogs

Browse by Tags

• best practice
• Checkpoints
• configurations
• connection manager
• Dataflow Task
• Microsoft
• ole db source adapter
• raw files
• SQL Server Integration Services
• SSIS
• template
• Variables

• SSIS: Suggested Best Practices and naming conventions

  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 Read More... Posted 05 January 2006 12:13 by jamie.thomson | 58 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, connection manager, Microsoft, Dataflow Task, Scripting, Expressions, best practice, configurations, Variables, Checkpoints, template

• SSIS: Custom Logging Using Event Handlers

  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 Read More... Posted 11 June 2005 15:29 by jamie.thomson | 119 Comments Filed under: SQL Server Integration Services, SSIS, Scripting, Expressions

• SSIS: Dynamic modification of SSIS packages

  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 Read More... Posted 28 February 2005 23:02 by jamie.thomson | 78 Comments Filed under: SQL Server Integration Services, SSIS, Scripting, Expressions