dbTalk Databases Forums  

Execute Package Task issue

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Execute Package Task issue in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
c0derguy
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.