troubleshooting Question

SSIS 2008--go to different task based on condtion

Avatar of niceguy971
niceguy971 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008SSIS
4 Comments3 Solutions267 ViewsLast Modified:
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

Jason Yousef
Sr. BI Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros