blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

SSIS Junkie

Conchango are busy and need talented consultants in and around London. Interested? Email me or send me a message

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

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