Can anyone offer a code snippet that will allow me from a Child DTS Package, modify settings on the Parent DTS package.
DTSPack1 calls DTSPack2. Within DTSPack2 some of the connection settings inside DTSPack1 are changed. When DTSPack2 returns to DTSPack1 the adjusted settings would be executed.
Below is a code snipped that changes a connection setting within the parent package - but I want to execute this from a child package. So the first line that refers to Set oPkg = DTSGlobalVariables.Parent I would think needs to be changed to refer to the parent DTS package - but I can't figure it out:
' Get reference to current package
Set oPkg = DTSGlobalVariables.Parent
' Get Tasks collection
Set oTask = oPkg.Tasks
'Set up Connection
Set oConn = oPkg.Connections("PAC")
oConn.DataSource = oRS.Fields("SrcDSNName")
oConn.Password = oRS.Fields("SrcDSNPass")
oConn.UserID = oRS.Fields("SrcDSNUser")
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200