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 |
|
samu_78_nyc
Starting Member
11 Posts |
 Posted - 2008-03-19 : 12:09:35
|
| Hi all,I have a Prod SSIS package and I need to changed the server name from SERV2 to SERV16. I changed it and tested the connection and it works fine.I saved the package but when I opened the Package the name of the server is unchanged.Do I need to rebuild the package and deploy it again?Thanks all. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-19 : 12:12:28
|
| WHere did you change the server mapping? |
 |
|
|
samu_78_nyc
Starting Member
11 Posts |
Posted - 2008-03-19 : 12:16:22
|
| Used the below information to change the server name.--To modify a connection manager using a connection manager dialog boxIn Business Intelligence Development Studio, open the Integration Services project that contains the package you want.In Solution Explorer, double-click the package to open it.In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.In the Connection Managers area, double-click the connection manager to open the Connection Manager dialog box.To save the updated package, click Save Selected Items on the File menu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-19 : 12:25:37
|
| Ok..did you notice the name of connection manager? does that include server name? |
|
|
|
samu_78_nyc
Starting Member
11 Posts |
Posted - 2008-03-19 : 12:33:12
|
| Let me re phrase what I did.I opened a new Integration service project through Business IDS.I added the existing package ( The one that needs the modification) using the solution explorer. I then followed the above steps to change the connection information and saved the package.Yes, The connection Manager has the server information along with user/pwd. I tested the connection using the new server name and it works fine. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-19 : 12:38:52
|
| Nope i asked the name of connection manager that existed. does that include server name? |
|
|
|
samu_78_nyc
Starting Member
11 Posts |
Posted - 2008-03-19 : 13:29:19
|
| The name of the connection manager DbGampProd and it does not include the server name |
|
|
|
|
|
|
Update server name in connection manager - SSIS