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 |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2008-09-22 : 10:01:31
|
| I'm new at SSIS and am just trying to modify the SMTP address for an email. (I'm probably making some rookie mistake)Here's what I did:Logged on to the SQL box directly1) Started SSIS, navigated to the package: Stored packages -> MSDB -> MyFolder -> MyPackage.2) right click "Export Package", set Package location=File System, set Package path = D:\SQL\SSIS_Packages\MyPackage.dtsx3) On server, navigate to: D:\SQL\SSIS_Packages\MyPackage.dtsx, right click "edit"4) At bottom in "Connection Manager" tab, highlight "SMTP Connection Manager" 5) in Properties pane on the right, change "SMTPServer" value to from 1.1.1.1 to 1.1.2.26)Click back in body of package, then save to D:\SQL\SSIS_Packages\MyPackage.dtsx (Windows shows new modified date)7) Right click and "edit" on D:\SQL\SSIS_Packages\MyPackage.dtsx that I just modified and it shows the old IP address 1.1.1.1Thoughts ??Thanks |
|
|
naveenka
Starting Member
1 Post |
Posted - 2008-09-22 : 10:14:17
|
| May be the package has 'Package Configuration' enabled and the SMTP Connection Manager IP is persisted in the package configuration.So every time you open the package it could be loading from the package configuration. If you disable the package configuration then it should be able to use your new settings.NKA |
 |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2008-09-22 : 10:38:37
|
| Thanks, I think you might be right. In the package I can see the Package Configuration settings, but they are greyed out. Where can I make the change for this and all packages to use the new SMTP setting ?Edit: I tracked it down to being stored in the "SSIS Configurations" table in the user database, so I'm modifying the table contents. I hope that works. |
|
|
|
|
|
|
SSIS Changes Not Getting Saved