Showing posts with label templates. Show all posts
Showing posts with label templates. Show all posts

Friday, March 23, 2012

Package Templates?

Can we create template packages? Where do we place them? Is this supposed to be VSI based now?This was described by Donald Farmer himself:

You can save a package to this location and it can be used as a template package. Right click on the Packages node of the project and select ��Add new item��

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE
\PrivateAssemblies\ProjectItems
\DataTransformationProject\DataTransformationItems

You cannot save and reuse individual objects within a package, but you can copy and paste between packages which can be useful for reusing objects.

|||Doug,

That doesn't seem to work anymore. I recall this from Donald, and tried it again recently, but no joy. Is it just me? I assumed that this may not work since Donald wrote that some time ago, back when BIDS was separate.

Package templates

Greetings SSIS friends,

I am currently reading Ralph Kimball's "The Microsoft Data Warehouse Toolkit". In the book it mentions creating template packages to speed up the creation of future packages. In the book they also mention creating solutions and projects.

All sounds fair enough but I am confused a little.

Where should the template package be stored?! I created a Project and renamed the default package as "TemplatePackage". I setup some standard data sources and package variables. Do I now create a new package and place it in the same project? Or should my template package be deleted from the project?!

Hope my questions makes sense.

Package Templates
(http://wiki.sqlis.com/default.aspx/SQLISWiki/PackageTemplates.html)|||

That's brilliant.

Thanks a bunch!

sql