Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tomailvenky
Starting Member
7 Posts |
 Posted - 2010-05-10 : 13:07:34
|
| 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 dynamicIn child package dynamicpropertiestask---->Text(source)------>TransformDataTask----->ConnectionPropertiesHere In dynamicpropertiestask I have 2 global variables one is textfilepath second one is .udl path ,now I need to create another for new text fileMy 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. |
|
|
|
|
|
DTS Dynamic property task