Welcome to EMC Consulting Blogs

Browse by Tags

• best practice
• Checkpoints
• configurations
• connection manager
• Dataflow Task
• Expressions
• indirect configurations
• Microsoft
• Nugget
• ole db source adapter
• raw files
• Scripting
• SQL Server
• SQL Server Integration Services
• 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: New suggestion for templates in Katmai

  I have raised a suggestion on Connect for a change to the current behaviour of SSIS templates. Here are the details: Description: When you use template packages you run into problems. Mainly because all of the packages created from the same template have Read More... Posted 15 May 2007 20:34 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SSIS, template

• SSIS: Package Template

  Someone recently left a comment on my blog about Package Template Locations asking if I could share my own template. I answered that I couldn't because I didn't have my own template that I use on all projects, across the board. It did give me Read More... Posted 11 March 2007 03:10 by jamie.thomson | 10 Comments Filed under: SQL Server Integration Services, SSIS, template Attachment(s): TemplatePackage.zip

• SSIS: Common folder structure

  For reasons that I'll save until another post , I always deploy my packages as files rather than to SQL Server. In doing this I have derived a folder structure that I use in order to keep all my deployed packages and other files in the same place: Read More... Posted 05 January 2006 15:19 by jamie.thomson | 37 Comments Filed under: SQL Server Integration Services, SSIS, raw files, best practice, configurations, Checkpoints, template, indirect configurations Attachment(s): PackageToUseCommonFolderStructure.zip

• 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: Location for your package templates

  Phillipe Cand asked me recently where you should put your SSIS templates so that you can use them as the basis for your packages. The answer is: %ProgramFiles%\Microsoft Visual Studio 8\Common7 \IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItems Read More... Posted 12 November 2005 14:17 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS, template