January 14, 2009 at 1:22 pm
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
January 14, 2009 at 1:51 pm
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
January 15, 2009 at 8:52 am
Thank You Jack. Looks like I can figure out what I need to do with that blog information! I appreciate it ALOT!
~MJ
~mj
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply