September 22, 2014 at 10:09 am
Hi - I've built an Intergration Services package on a SQL2005 Test environment. I have run through the debugging process and everything is working as I would expect.
I would now like to copy the full project across to another SQL2005 Server without having to manually build the process. Can anyone advise the best steps needed to achieve this?
Any help would be very much appreciated.
Kind Regards
Dax
September 22, 2014 at 10:18 am
Is your package deployed to sql server and stored in msdb?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 22, 2014 at 10:28 am
Hi - Yes the package has been deployed to the Test MDSB database.
Regards
Dax
September 22, 2014 at 10:34 am
With it in msdb, you can simply import the package from the test server. Meaning, connect to your other server and use the import option in the ssis store.
Alternatively, you can just deploy the dtsx file from your project to this other server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply