April 3, 2009 at 1:41 am
Ok, Iv started again.
Now when I hit "Evaluate Expression" i get the correct result (i.e. the SMTP Server address).
I have done your revised steps but I still keep getting the error:
"The connection xxxxx.xxxx.xxxx.xxx is not found......"
April 3, 2009 at 2:44 am
A Little Help Please (4/3/2009)
Ok, Iv started again.Now when I hit "Evaluate Expression" i get the correct result (i.e. the SMTP Server address).
I have done your revised steps but I still keep getting the error:
"The connection xxxxx.xxxx.xxxx.xxx is not found......"
If you followed my revised steps correctly, it should execute successfully, I tried myself first before posting.
One thing that you need check whether the property "SmptConnection" in Send Mail Expression Editor > Property Expression Editor is available, if it is then remove it.
And also, post back the exact errors that returned by SSIS
--Ramesh
April 3, 2009 at 3:06 am
Woohooo ok I think iv got it working.
Now just to test this, how can I use this Variable I have now created (which stores the SMTP Server details) in another package?
April 3, 2009 at 4:53 am
Using Package Configurations...(see BOL link: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/9b939edb-4e17-48e5-8428-855beb10049c.htm)
--Ramesh
April 3, 2009 at 5:05 am
is this the correct URL?
Page does not open...
April 3, 2009 at 5:42 am
A Little Help Please (4/3/2009)
is this the correct URL?Page does not open...
If you've books online installed on your local machine, just copy & paste that link to see the relevant documentation.
--Ramesh
April 3, 2009 at 7:02 am
This page cannot be displayed!
Viewing 7 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply