SSIS Standards

These standards are guidelines to follow when developing SSIS packages.



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



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