[Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Start Query in SSIS- Once Multiple Steps Completed

I have several steps that are running at one time in a single SSIS package (using 2008 MS SQL Server with SSIS). For example, there is a data transformation step,  SQL Statement, etc all running at once. I need some way to say when all of these steps are run successful, only then run a query.  I know how to do this when a single step is done, but not with multiple.

If someone could provide me the steps in detail, that would be great.  Providing just a web link alone may not be enough. I may have some questions etc when I try it.  Please be available for any questions I have when I try would be great.
1 Solution
You do it the same way.  Using the designer you drag the green arrows to the next task, that next task will run when all of the previous tasks are successful.
jjrr007Author Commented:
That worked.  Thanks

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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