SSIS project can be saved as a template to share between team members and it’s very easy to do:
Open a SSIS project that will be saved as a template and save it underC:\Program Files (x86)\Microsoft
Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject
It’s done. Now let’s create a new project and use the template we just created:
Next step is to change package ID:
This template is ready for further development.