Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

SSIS: But it used to work in DTS (8) - Get a reference, within a script, to the package using DTSGlobalVariables.Parent

Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.


Get a reference, within a script, to the package using DTSGlobalVariables.Parent

In DTS ActiveX scripting it was common to get a reference to the package itself using the following line of code:

Dim pkg = DTSGlobalVariables.Parent

This was used to navigate over the DTS object model, usually in order to dynamically alter the package while it is executing.

People have rightly been asking how to do the same thing in SSIS. Well, there isn't actually a SSIS equivalent. The main reason for this is that, as stated here, it is not possible to manipulate an executing package using script code. You will find that all the requirements you used to achieve in DTS are still achievable in SSIS, you just need to learn the new methods of achieving them.

-Jamie

 

 

Published 26 July 2006 15:53 by jamie.thomson

Comments

 

Jim said:

Wow that's unhelpful

February 9, 2007 20:16
 

Mike said:

I agree with Jim.  

"...you just need to learn the new methods", isn't that what we are looking for?

February 27, 2007 15:51
 

jamie.thomson said:

February 27, 2007 16:15
New Comments to this post are disabled

This Blog

Syndication

Powered by Community Server (Personal Edition), by Telligent Systems