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)
 DTS Object Model - Making Dynamic Properties Tasks More Dynamic

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-06 : 07:37:39
Jason writes "Hi,

BACKGROUND:
I've got a routine that I would like to make more generic for better reuse. I'm using the Dynamic Properties Task component in DTS and am retrieving package specific variables from a table via a stored procedure that I wrote.

QUESTION:
I'd like to access the name of the package from the Dynamic Properties Task so that I can pass it as a parameter to the query to retrieve the package variable specific to that package. Is there somewhere I can view the DTS Object Model or class hierarchy? It'd be nice to know the variables for things such as Current Package Name and Component Name.

I'd appreciate your help.
Jason"
   

- Advertisement -