Solved

How to delay ssis sql execute task before starting with anoter ssis execute task

Posted on 2011-03-15
2
734 Views
Last Modified: 2012-05-11
In ssis I have "sql execute task1" which upon completion it will execute another "sql execute task2",how can I delay the execution for eaxample task 2 is running after 5 min task1 completed
0
Comment
Question by:motioneye
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 250 total points
ID: 35135750
0
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 250 total points
ID: 35136037
Just add the flow line form "sql execute task1" to "sql execute task2".
which will excute 1 first and then 2nd

see the image in red csquare
1.JPG
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now