Untitled.png

<div>
expert sage thanks:<br />
However not sure what I have to do relative to:<br />
&quot;You should have your variable declared and filled in precedent step...&quot;<br />
My 1st task Execute SQL task which runs a &nbsp;SQL script that currently sets database field SubmitEmail UPDATE TableA<br />
SET SubmitEmail = 1<br />
WHERE ....etc...<br />
but when i click the Test button on the above panel I get error &quot;varible SubmitEmail not found&quot;?<br />
SubmitEmail is a field in my database. Do i have to create and declare and set a new seperate field say called SubmitEmail2 and add it somewhere in the task #1 properties? not sure what to do here?<br />
help<br />
<br />

</div>


<div>
Ok so you have a SQL task1 in your package right? In that SQL task you must declare the variable to be used by the send_email_task2 and fill it in with 1 if you want the mail to be sent by the second task.
</div>


<div>
thanks all and yes the above select clause was missing and helped to turn the Precedence Contstraint arrow green which is located between task#1&quot;Execute SQL task&quot; and 2nd task &quot;Send Mail task&quot;. However the Send Mail task does not fire or execute athough it will send email out when I select it and manually execute it. It does not fire after the Precedence Contstraint &nbsp;is satisfied and no errors appear in the output window. Have to figure out what's missing and preventing Send Mail task to automatically execute? Will vote if no one can resolve this? again, thanks all
</div>


<div>
<div class="content wysiwyg-content">
Expert:<br />
How do you set-up a Precedence Constraint between 2 tasks, 1st task is a &quot;Execute SQL task&quot; and the &nbsp;2nd task is a &quot;Send Mail task&quot; &nbsp;in a SSIS 2005 package. The Send Mail task should not work or become activated and workflow should not proceed until a variable called &quot;SubmitEmail&quot; in the Execute SQL task (or sql query script) is set SubmitEmail=1. Please show me the details how to set this up!<br />

</div>
</div>


Expert:
How do you set-up a Precedence Constraint between 2 tasks, 1st task is a "Execute SQL task" and the  2nd task is a "Send Mail task"  in a SSIS 2005 package. The Send Mail task should not work or become activated and workflow should not proceed until a variable called "SubmitEmail" in the Execute SQL task (or sql query script) is set SubmitEmail=1. Please show me the details how to set this up!


How do you set-up a Precedence Constraint between 2 tasks in a SSIS package

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.