September 19, 2008 at 2:45 pm
I'm new at SSIS and am just trying to modify the SMTP address for an email.
Here's what I did:
Logged on to the SQL box directly
1) 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.dtsx
3) 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.2
6)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.1
Thoughts ??
Thanks
September 22, 2008 at 9:43 am
FYI, With help from naveenka on another forum, I think I found the problem.
The package uses an SSIS Package Configuration, that is pointing to the "SSIS Configurations" table in "My_Database". I manually modified the SMTP entries in the table, and when I exported the package, the new values appeared, so there's no need to modify the package itself. I haven't tested yet, but it looks good.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply