Access Object Variable containing Result Setin Script Task

• M Jones

  SSCommitted

  Points: 1711

  More actions

  January 14, 2009 at 1:22 pm

  #126610

  I have created an ExecuteSQLTask that builds a resultSet of multiple rows that I have stored into a Variable of type Object.

  Now I need to access this resultSet object in a ScriptTask to work with the Data via VB.NET.

  In the ResultSet Property page of the ExecuteSQL Task Editor, I mapped the ResultSet with Result Name = 0 and Variable Name = User::rstCat1 of type Object (yes, I specified Full Result Set).

  The problem is in the ScriptTask - I can't figure out how to access my variable to get to the data??

  Anyone help me here?

  Thanks!

  ~mj

  ~mj

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 14, 2009 at 1:51 pm

  #926937

  Here's a blog post that I think will help: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• M Jones

  SSCommitted

  Points: 1711

  More actions

  January 15, 2009 at 8:52 am

  #927423

  Thank You Jack. Looks like I can figure out what I need to do with that blog information! I appreciate it ALOT!

  ~MJ

  ~mj