Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2008-09-04 : 18:48:09
|
| Hi,How would I migrate an SSIS to a new server. The SSIS was not saved as a file.Thanks,-Long |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 18:59:49
|
| If you haven't saved as file,then it should be saved in MSDB database. Use package Migration Wizard to transfer your SSIS package to other server. You can use Package config to update all packages to new server name. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-09-04 : 19:00:57
|
| Using Management Studio connect to Integration Services. Expand the Object Explorer to the package(s). Then right-click and select Export Package. |
|
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2008-09-05 : 11:30:24
|
| Hi,Thanks, for the replies. I was wonddering, if you saved it as a file. How do you import it into the database?Thanks |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-09-05 : 12:39:11
|
| You can Import the package using Management Studio or there is a commandline utility that can do that (I forget the name of it). |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-06 : 23:50:26
|
quote:
Originally posted by nguyenl
Hi,Thanks, for the replies. I was wonddering, if you saved it as a file. How do you import it into the database?Thanks
Connect to Integration Services instance of your server. then expand MSDB and right click, select export package. then browse and select your saved ssis file. then give suitable security mechanism. it will be exported to server. |
|
|
|
|
|
|
SSIS to new server