DTS Script Task Help

Last Post 30 Nov 2004 03:45 PM by knight_reign. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mike_lyk
New Member
New Member

--
02 Nov 2004 07:56 AM
Hello -

I included a script task written in VB.Net within my DTS package. Is there a way inside of the script to reference SQL Connection objects outside of the Script Task (In the DTS package)?

Thanks in advance!
knight_reign
New Member
New Member

--
30 Nov 2004 03:45 PM
Hi Mike,
Did you ever get an answer to this question?
Yes, there is a way.
You may access all the connections in the script task via the "Dts" object.
Dts.Connections gets the collection.
If you have a connection with the name "SQLDst", you would get it like this:
Dim connSQLDst as Connection = Dts.Connections("SQLDst")

Hope this helps,
K
You are not authorized to post a reply.

Acceptable Use Policy