Showing posts with label quotthe. Show all posts
Showing posts with label quotthe. Show all posts

Friday, March 23, 2012

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

Wednesday, March 21, 2012

package index server

I keep getting a message when I try to do a system update for my lenovo computer, which prevents me for using this utility. "the package index server is temporarily unavailabe, please try again later". Surprisingly, Lenovo could not provide me with any assistance in this matter.Confirm the SQL Server configuration and system too, i don't think this is related to SQL SErver.