I have a Main dts package,In that by using execute package task I will call another child DTS package(see diagram),I am passing paths through global variables,In child package I am getting error , The child DTS is for pumping data into table by reading text files,these text files are dynamic
In child package
dynamicpropertiestask---->Text(source)------>TransformDataTask----->ConnectionProperties Here In dynamicpropertiestask I have 2 global variables one is textfilepath second one is .udl path ,now I need to create another for new text file
My question is how to set global variables in dynamic properties If I click on existing dynamic package it is showing 'Cannot locate the DestinationPropertyID'
'Connections'
'CONTROL_FILE'
'OLEDBProperties'
'DataSource'
'Properties'
'value'
In google I found through vb code how to add global variable, but I need In dynamic properties task after clicking add how set these values.
