[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4420
  • Last Modified:

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
0
kwebster7327
Asked:
kwebster7327
1 Solution
 
Anthony PerkinsCommented:
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now