posted on Tuesday, December 27, 2005 11:33 AM by bknight

Templates in SSIS

Templates in SSIS provide a great way to create standards across your company or enterprise. For example, you may want to enforce a standard annotation set of notes at the top of each package or have each package come with a standard set of connections or error handlers to speed up development. To use a template, first create a package just as you would want to see it as a template. Add all the connections, tasks, comments or log providers. After the package meets your needs, copy it to the following directory (of course replace %Program Files%) : %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItems

For a developer to consume the template, he must only right-click at the project-level node in BIDS and select New Item. You'll see the package you copied over there and once selected, all your information you created earlier is ported over.

-- Brian Knight

Comments

# re: Templates in SSIS

Monday, January 09, 2006 1:39 AM by Noa
Is there a way to run a wizard whenever a developer chooses my template package in the "new item" dialog?

thanks.

# re: Templates in SSIS

Saturday, December 15, 2007 2:40 PM by minikperi
Templates in SSIS)

# Renumbering Package IDs in an Automated Fashion

Wednesday, March 12, 2008 6:05 AM by Brian Knight
I'm now a huge advocate of using package templates. For more info on how to use them see this post

# Renumbering Package IDs in an Automated Fashion

Wednesday, March 12, 2008 9:31 AM by Brian Knight
I'm now a huge advocate of using package templates. For more info on how to use them see this post