InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:15:22 GMT20http://www.sqlservercentral.com/Forums/Topic751952-364-1.aspxThe 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 [url=http://support.microsoft.com/kb/908018]http://support.microsoft.com/kb/908018[/url] and [url=http://msdn.microsoft.com/en-us/library/ms345191%28SQL.90%29.aspx]http://msdn.microsoft.com/en-us/library/ms345191%28SQL.90%29.aspx[/url].Tue, 15 Dec 2009 09:12:07 GMTJason Criderhttp://www.sqlservercentral.com/Forums/Topic751952-364-1.aspxI 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.Fri, 24 Jul 2009 05:00:10 GMTsameer.mirzahttp://www.sqlservercentral.com/Forums/Topic751952-364-1.aspxHi aaathnx 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.CheersIshTue, 14 Jul 2009 05:14:06 GMTiswarya.dhandapanihttp://www.sqlservercentral.com/Forums/Topic751952-364-1.aspxThe 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.Mon, 13 Jul 2009 06:23:24 GMTaaa-322853http://www.sqlservercentral.com/Forums/Topic751952-364-1.aspxHi AllIn order to create package template in SSIS, the package has to be stored at a specific locationie., C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItemsThis 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.ThanksIshMon, 13 Jul 2009 05:52:21 GMTiswarya.dhandapani