July 13, 2009 at 5:52 am
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
July 13, 2009 at 6:23 am
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.
July 14, 2009 at 5:14 am
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
July 24, 2009 at 5:00 am
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.
December 15, 2009 at 9:12 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply