SSIS Package Template

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS Package Template

SSIS Package Template

Rate Topic

Display Mode

Topic Options

Author

Message

iswarya.dhandapani

Posted Monday, July 13, 2009 5:52 AM

Forum 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

aaa-322853

Posted Monday, July 13, 2009 6:23 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:25 AM
Points: 288, Visits: 674

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

iswarya.dhandapani

Posted Tuesday, July 14, 2009 5:14 AM

Forum 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

sameer.mirza

Posted Friday, July 24, 2009 5:00 AM

Grasshopper

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

Jason Crider

Posted Tuesday, December 15, 2009 9:12 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:31 AM
Points: 282, Visits: 2,123

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 »

Permissions