July 6, 2008 at 8:28 pm
Hi ,
1.Can any body tell me that how can we move SSIS packages from one server to other?
2. What can be the dimensions and facts for creating cube in a real state office?
July 7, 2008 at 6:58 am
One method for moving an SSIS package from one server to another is the following:
1. Connect to SSIS within Management Studio
2. Locate the package you want to move
3. Right click on the package & click export
4. Fill in the name of the server that you want to move it to.
5. Type in the name of the SSIS package into the Package path
6. Click ok & you should be good to go.
Another method would be to use BIDS to save a copy of the SSIS package to the other server. I believe it is File/Save a copy as. You will then get the same window as you did if you followed the instructions above.
Not to state the obviouse but just in case, this merely copies the package to the new server & does not necessarily mean the package will run. You will need to verify that on your own.
HTH,
John
July 7, 2008 at 11:56 am
Thannks a loott,
Jr.DBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply