We have developed a custom SSIS task to ... do some proprietary stuff.
It has a bunch of public properties, including
Category("Email"), Description("URL ...")> _
Public Property EmailWebServiceURL() As String
Set(ByVal value As String)
sEmailWebServiceURL = value
The Validate routine checks that this property is set:
If Active Then
If EmailWebServiceURL = vbNullString Then
0, "Email Web Service Task", "You must provide the URL of the EmailWebService", vbNullString, 0)
'go validate more stuff
In our development environments, this works fine. But on our test environment, the package that calls this component is getting the error above -- "You must provide the URL ..."
Same component, same package.
As shown in the attached picture, the properties are being set from user variables.
On the TEST environment, we have traced the SQL statement that retrieves the value for the variable. Rerunning that statement yields the value we expect.
What could be causing this problem?