SSIS Template that can be shared among developers

[IowaTiger]

I created a SSIS package which I want to use as a template for future packages. I used Windows Explorer to copy the .dtsx file into my C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItems folder. This is great for me. When I'm in a solution/project, I can simply Add New Item and use this template. However, I would like to save it in the network File System so all of the developers can share the same templates. How do I go about doing that? I have already gone to TOOLS-OPTIONS-PROJECTS & SOLUTIONS and changed the "Visual Studio user project templates location" and "Visual Studio user item templates location" to a folder on a shared drive. However, when I try to Add New Item, the template does not appear in the list. I don't want to save a template on my c: drive because I want to be able to share it with others easily.

 

[MDXer]

Template packages pretty much suck in SSIS unless you understand some of the inner workings.

SSIS utilizes GUIDS for packages and the various pieces of the package. if you utilize a template then all your templates have the same GUIDS. You can reset a package GUID from within the properties. To reset the other GUIDS you need something like BIDS helper from codeplex. If you don't reset all of the GUIDS you risk the chance of a child package executing a step in a parent or another package.

The only way to enable a template is to place the file in the template path which I believe needs to be a local path.