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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Global Variable And Execute Package Task

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-20 : 09:12:43
Vijay writes "I am calling a DTS in a DTS by using "Eecute Packge Task". I am using global variabe to pass to the child package. The child package is not picking up the gloabl variable which I am passing to the parent package. I checked every thing no luck. Any suggestionsss????

Also I am doing the auditing on my package execution, For failure or success of every task in my parent packge I want my child package to update the Audit table. For that I need to pass the package name and task name then the child package will update the Audit table. I am using global variables and I wanted to upadte the task name dynamically??? I am not understanding the DTS objects, Can I do by the ActiveX script then how I get the task name and assign to my global variabe???


Regards

Vijay"
   

- Advertisement -