SSIS Standards

These standards are guidelines to follow when developing SSIS packages.

 

Variables:SSIS_Variables

Always prefix variables with “var_” and use camel case for the remainder of the name.

example:

var_DailySalesFileName

Connection Mangers  SSIS_ConnectionManagers

 

 

 

Create separate schemas for in your ODS and DW for each application.  I find it very useful to create an Import schema that can be used as a standard way to load files into SQL Server.  This schema can be used to load all flat files.

Leave a Reply