blogs.conchango.com

Browse by Tags

• configurations
• connection manager
• Dataflow Task
• Expressions
• indirect configurations
• Microsoft
• ole db source adapter
• raw files
• Scripting
• SQL Server Integration Services
• template
• Variables

• 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 | 54 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