Solved

Precedence Constraint in SSIS

Posted on 2009-04-06
1
377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 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