Execute Package Task issue -
12-08-2005
, 05:16 PM
SQL 2000 SP4
DTS Designer
I recently copied a DTS package with an Execute Package Task from one Server
to another.
I am now changing connection properties programmatically in this "Execute
Package Task" object so that it can run in different environments with
different servers.
I am able to change the server values just fine and also switch from a user
Name and password, to "Trusted Connection" or Windows Authentication.
My problem seems to be that when I do that, and I use the designer to view
either the inner variables, or the the (...) browse package feature. It
doesn't recognize that the server exists.
However, what seems to be odd, is that after already setting the
UseTrustedConnection=True programmatically (I've tried both Dynamic task, and
Active X methods with same results) and verifying it is set in the designer
to Windows Auth -- If I click on the "Use SQL Server Auth" once and then
back to "Use Windows Auth" again -- it is able to use the (...) browse
package feature and I can see the packages for this server. Notice I didn't
change anything, I just toggled the Auth type radio button.
It almost seems like it is running a refresh (the InitializePackage run time
method?) when I use those radio buttons. This seems like a bug. Any
thoughts?
How can I accomplish what I have set out to do which is to successfully set
the connection parameters (including auth type) programmatically and have
them take effect?
Thanks,
Lorne |