SQL 2005 SSIS Script Task - Run a Query

Easy points:

How about an example of how to run a SQL query from within an SQL 2005 SSIS Script Task using an existing connection?

Thanks
LVL 1
kwebster7327Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Check this link out:
The ExecuteSQL Task
http://www.sqlis.com/default.aspx?58
0
 
kwebster7327Author Commented:
That's useful (I'll definitely bookmark it), but I need to run a couple queries from <B>within</B> a VBScript task. Seems like a lot of effort to have to load up variables, jump out to a SQL task (or two), then jump back into another VBScript task. Actually, my scenario would require a flow likescript->SQL->script->SQL->script.

You'll get the points if nobody else comes up with a more spot-on answer- just for that link.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.