blogs.conchango.com

Browse by Tags

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

• SSIS Nugget: Ensure your root folder is valid

  In the past I have advocated (and still do advocate) the use of a user variable in SSIS packages to store the path to a folder on the hard drive; I always use a variable called @[User::RootFolder] for this. Having this path available within a package Read More... Posted 19 May 2008 11:57 by jamie.thomson | 3 Comments Filed under: SQL Server, SSIS, Microsoft, Expressions, template, Nugget

• SSIS Nugget: Construct a timestamp value

  Visitors to the SSIS forum often ask how to construct a date string in the form YYYYMMDDHHMISS (e.g. "20070207123456" for "7th February 2007, 12:34:56") using a SSIS expression. I always give the same answer so I thought I'd post Read More... Posted 07 February 2007 22:41 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, Expressions, 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 | 53 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