Link to home
Avatar of niceguy971
niceguy971

asked on

SSIS 2008--go to different task based on condtion

In my SSIS package (2008) I get RecordCound.. based on RecordCount  I would like to do the following:

1) If RecordCound ==0  go to 'Execute Sql Task 3'

2) If RecordCound > 0  go to 'Execute Sql Task 2'

The execution always goes to 'Execute Sql Task 3 even if RecordCound > 0.

What needs to be corrected in SSIS package to fix it??

The package Vetka.dtsx is attached..pls rename to .*.dtsx

Thanks
Vetka.txt
SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of niceguy971
niceguy971

ASKER

Thanks