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 an idea though; I could put together a template that exhibited as many suggestions as possible from my list of Suggested Best Practices and naming conventions for SSIS and that's what I have done and attached it to this blog post. You can download it from here.
It exhibits all of the following characteristics:
- Use of a common folder structure (via variables)
..\RootFolder\BLOBTempStorage
..\RootFolder\BufferTempStorage
..\RootFolder\BLOBTempStorage
..\RootFolder\CheckpointFiles
..\RootFolder\ErrorFiles
..\RootFolder\LogFiles
..\RootFolder\Packages
..\RootFolder\RawFiles - RootFolder location is set using an indirect configuration
- Dynamically named log file
- Concatenated package name and version numbers in a variable
- ProtectionLevel=DontSaveSensitive
- Configurations are enabled
- Descriptions are filled-in
- All variables in the template have a dedicated namespace
- All expressions are in variables
- Use of annotations
- Checkpoint file name and location is set dynamically
- Basic logging setup
I don't expect this template package to be something that you can use straight from downloading it, but it may form a basis for your own templates. Most likely you have your own naming conventions and/or you have specific functionality that needs to be in every package (e.g. eventhandlers). Hopefully this will trigger some of your own ideas about what to put in your own templates.
Comments are welcome.
-Jamie