April 4, 2006 at 9:40 am
Hi,
I am trying to get us input into how everyone is handling SSIS packages. I think I finally understand how to save the packages to SqlServer. Can you share how you're doing this? Do you save on the server itself then deploy and when you need to modify a package do you just modify the one that was saved on the server?
It seems like a lot to go through or am I missing something very simple.(I hope so)
Thanks
April 4, 2006 at 11:27 am
In every enviroment I have worked in, the packages have been saved as files, and then the files can be transported to whatever enviroment you want, by copying the files as part of a build. When they are saved within the server itself, it becomes much more problematic....
April 6, 2006 at 10:44 am
We deploy our packages (it is irrelevant where to) and keep all our work done in teh development stage in SourceSafe. We make changes in the development environment and then deploy new versions of the packages in exactly the same way.
We don't take a package from where it has been deployed to and then edit it.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply