SSIS-PrecedentConstraint.JPG

<div>
<div class="content wysiwyg-content">
Hi,<br />
In my ssis package I have two task execute sql task (1)and data flow task(2). and one variable<br />
@client_id..<br />
I want the package flow must go to data flow task from execute sql task.If the variable client_id<br />
must be equal to &nbsp;21 (or) 10<br />
I set the precedence constarint as <br />
@client_id in (21,10).<br />
But it was showing error as Invalid token<br />
<br />
Thanks and Regards,<br />
Coventri
</div>
</div>


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

Precedence Constraint in SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.