Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package Template Expand / Collapse
Author
Message
Posted Monday, July 13, 2009 5:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 15, 2009 4:49 AM
Points: 2, Visits: 19
Hi All

In order to create package template in SSIS, the package has to be stored at a specific location

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

This is not really helpful as it stops the template being used by other developers of the project.

Please can someone suggest a way of storing the package at a common network location which will be accessible to everyone.

Thanks
Ish
Post #751952
Posted Monday, July 13, 2009 6:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 6:47 AM
Points: 319, Visits: 783
The only other thing I have every came across is saving the package template within the solution itself so other developers can copy, paste it and then rename it before progressing.
Post #751972
Posted Tuesday, July 14, 2009 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 15, 2009 4:49 AM
Points: 2, Visits: 19
Hi aaa

thnx for your alternative method.

It will be really nice to know how to change the location where the template can be stored.

Any help is appreciated.

Cheers
Ish
Post #752575
Posted Friday, July 24, 2009 5:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 20, 2010 6:54 PM
Points: 18, Visits: 98
I think you can simply store the package in msdb and every time you require to use that template you can import package in BIDS, make changes to it and save it with another name/another location as desired.

Post #758935
Posted Tuesday, December 15, 2009 9:12 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:41 AM
Points: 282, Visits: 2,210
The way that I'm doing it currently is to save the template out on a network share and then have them copy it to that location locally.

More documentation on this can be found at http://support.microsoft.com/kb/908018 and http://msdn.microsoft.com/en-us/library/ms345191%28SQL.90%29.aspx.


MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Post #834581
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse