Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Pkg Variables from external VB 2008 app Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 1:09 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 23, 2013 1:55 PM
Points: 3, Visits: 55
OK, this has driven me nuts so I need help from the experts. I've searched until I actually googled something and got one result. Didn't think that was possible but yeah it did.

Anyway, I'd like to be able to access package variables from my code in VB. Writing would be excellent, but even accessing them to start with has evaded me. I can't figure out the right combination of objects, collections, etc.

Is there any way to do this, and if so, could someone point me to syntax or a snippet, please?
Post #1444574
Posted Friday, April 19, 2013 1:21 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:06 PM
Points: 1,478, Visits: 1,025
Are you talking on execution, or is your app creating Ssis packages?

http://msdn.microsoft.com/en-us/library/aa337077.aspx
Post #1444581
Posted Friday, April 19, 2013 1:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 5:24 PM
Points: 262, Visits: 681
I think this is what you are looking for: Working with Variables Programmatically. You will be able to read and write to the variables collection.



Rick Krueger

Follow @dataogre
Post #1444591
Posted Friday, April 19, 2013 1:49 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 23, 2013 1:55 PM
Points: 3, Visits: 55
Just on execution ... Thanks for the link!!
Post #1444593
Posted Friday, April 19, 2013 1:49 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 23, 2013 1:55 PM
Points: 3, Visits: 55
Thanks dudes!!! The help is MOST appreciated!
Post #1444594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse