SSIS Pkg Variables from external VB 2008 app

• ASUMtnr

  Grasshopper

  Points: 13

  More actions

  April 19, 2013 at 1:09 pm

  #276681

  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?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  April 19, 2013 at 1:21 pm

  #1608371

  Are you talking on execution, or is your app creating Ssis packages?

  http://msdn.microsoft.com/en-us/library/aa337077.aspx

• Rick Krueger

  SSC Eights!

  Points: 856

  More actions

  April 19, 2013 at 1:47 pm

  #1608379

  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

• ASUMtnr

  Grasshopper

  Points: 13

  More actions

  April 19, 2013 at 1:49 pm

  #1608381

  Just on execution ... Thanks for the link!!

• ASUMtnr

  Grasshopper

  Points: 13

  More actions

  April 19, 2013 at 1:49 pm

  #1608382

  Thanks dudes!!! The help is MOST appreciated! 😀