Execute package one by one using SSIS

Hot Topic

Use Filters in Cascading Parameters (dependencies)
SMO
upgrade sql 2k std to sql2k5 problem with Reporting Services
Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services
Failed to acquire connection tempdb
Launching the Reports From Browser
Database Diagram + Reporting Services/Report Builder
Transfer Access database into SQL Server 2005 Express
Unable to read local eventlog (the parameter is incorrect)
Trying to SET a variable from a SELECT

SQL Server

Querying AS 2000 Cubes from SQLServer 2000
SQL Server Management
Creating a Data Source for a Model-Based Report in Report Designer
SQL 2005 and SQL 2000, one Dev server, co-existence
Pubs not installed?
Implement SQLXML Bulk Load using C++
Release date? 2005
Tricky Grand Total on Column Needed
Meta Data Services SQL 2000 "msdb database could not be opened"
prompt/parameter position in UI

Execute package one by one using SSIS

Hi,

I have created four package, it should executed sequencely one by one. Is it there any option like sequencer in Data Stage for achive this requirement I want to execute these package one by one using SSIS. could you help on this requirement

Thanks & Regards
S.Nagarajan

Answer this question

Execute package one by one using SSIS

  • Ankur Goel

    The workflow controller in SSIS is what you see in the Control Flow tab in SSIS Designer in BIDS. Its simply a case of dragging arrows between tasks.

    For slightly more advanced stuff, here's a great example of conditional workflow: http://www.sqlis.com/default.aspx 306

    and another one of implmenting logical OR in your workflow: http://www.sqlis.com/default.aspx 308

    -Jamie



  • Joltan

    Thanks. guide me or give me samples for using workflow in SSIS

    Regards

    S.Nagarajan

  • jandizon

    How about a new package that contains four Execute Package Tasks, each pointing to one of the four existing packages. Link the four tasks with workflow constraints, to force the execution order.

  • philippel

    Select a task, you will see the little green arrow hanging down. Drag the arrow to the next task.

  • Execute package one by one using SSIS
Answer this question