I have created several custom package templates, but they are a little cumbersome to use because there is no concept of macro substitutions like you have with a standard visual studio project template. From what I've researched so far, you can create
a project template from visual studio's file menu: File->Export Template. This in theory this launches the project template wizard. My only problem is that this menu item appears to be disabled for SSIS projects. Is it possible to create
custom project templates for SSIS? I'm using BIDS 2008.
View Complete Post