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 |
|
rauk10
Starting Member
16 Posts |
 Posted - 2009-01-12 : 16:33:06
|
| I have made one package on one server A. I had deployed that package on that server A. Now I want to run the same package on server B. What should I do? I tried copying the package into server B and running that package through the job. The job was successful but it was getting the data from the Server A not the Server B. I think we can do this by changing the configuration files but I was not able to do so. I would be really grateful if somebody could explain me how to do so.Thank you |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2009-01-12 : 17:25:37
|
| You need to change the SSIS package connection string from ServerA to Server B and update package. Since its still pointing to ServerA.hey |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-01-12 : 18:08:08
|
| there are great tools out there that will help you in the long run..to avoid making changes manually before deploying to test and finally to production server. you do not want packages running pointing to dev or test BELIEVE ME! |
|
|
|
rauk10
Starting Member
16 Posts |
Posted - 2009-01-13 : 00:41:22
|
| Can you guys suggest me any article where I can read this stuff.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 03:06:56
|
| http://www.sqlis.com/post/Easy-Package-Configuration.aspxhttp://www.mssqltips.com/tip.asp?tip=1405 |
|
|
|
|
|
|
Deployment of package