asked on

SSIS task only after previous task is sucess

Hi

i have SSIS package which has 2 tasks
task1. Execute SQl task
task 2. Move Processed file to archive directory

I want to execute task2 only when task1 is executed successfully. If Task1 is not executed not successfully, ( i mean if i get error while processing task1 that is while executing stored procedure ) , i do not want to execute task2
i am using Sql server 2005

thanks,
Ram

ASKER CERTIFIED SOLUTION

Saurabh Bhadauria

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SThaya

Here are the steps:

1.just give a Procendence constraint connection from task 1 to task 2 .
2. select the Procendence constraint link and select "Success" ..This will pass only the task 1 executes successfully

3. if the task 1 failed then your over all pakage will fail. in order to avoid that . create one more task (task 3){ send mail tak (or any other task) .}
4. connect Procendence constraint connection from task 1 to task 3 and select this Procendence constraint link and right click select "Failure"
image.jpg

SThaya

ram27

ASKER

I tried SThaya's approach
even my stored proc fails while executing,
Task 2 is executing
i want to execute task2 only when task1( Execute SQl task - which inter calls stored proc ) is executed sucessfully.
I mean id there is any error while executing the stored proc , it should not execute task2