Solved

Precedence Constraint in SSIS

Posted on 2009-04-06
1
362 Views
Last Modified: 2013-11-10
Hi,
In my ssis package I have two task execute sql task (1)and data flow task(2). and one variable
@client_id..
I want the package flow must go to data flow task from execute sql task.If the variable client_id
must be equal to  21 (or) 10
I set the precedence constarint as
@client_id in (21,10).
But it was showing error as Invalid token

Thanks and Regards,
Coventri
0
Comment
Question by:coventri
1 Comment
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 24078944
Coventri,
use this expression @client_id==1|| @client_id==2

Follow the attached image
SSIS-PrecedentConstraint.JPG
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

743 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

9 Experts available now in Live!

Get 1:1 Help Now