November 3, 2005 at 5:05 am
I have created the packages in SSIS. How can I make the back up of packages and how to move into the production?
November 3, 2005 at 9:44 am
We have been using VSS to hold the SSIS packages and we backup VSS every x minutes. This works very well.
If you use SQL Management Studio, go to the help menu and select "How Do I?". From here, follow the links to Deploying Integration Services packages. It will take you through the process of deployment.
November 4, 2005 at 12:05 pm
While working in Visual Studio the Solution you create is saved in Visual Studion 2005/Projects/<some name>. By default a directory is also created at the same level as Projects named Backup Files. An empty directory is also created there with the same "<some name>" as your Solution. The files in your solution are not automatically moved to Backup Files/.... You must put them there when you want a backup. I usually do this before every critical change to my package(s). And this is what I take home occasionally when I want to work there and have a bit of extra piece of mind. This is NOT a solution to code storage - and VSS is one such solution... and it is NOT a deployment method... the information in the previous post addresses that. This is a solution for backing up little changes while developing a package.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply