Welcome to EMC Consulting Blogs

Browse by Tags

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

• SSIS Nugget: Nesting variables to calculate values

  I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name: Public Sub Main() ' Dim sWeekday As String sWeekday = Now().DayOfWeek.ToString Dts.Variables( Read More... Posted 24 October 2008 10:44 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions, Variables, Nugget

• 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