<div>
ISO30: thanks. &nbsp;I am new to this SSIS stuff. If you can somhow show me how to loop thru records and send out email for those records flagged Email = 1 that would be great since I am not sure &nbsp;how to do this. Also I guess I would need some kind of &nbsp;job set-up to run the package say each morning? Also the email messages in body are not status and will need to to reflect data relative to that record. Not sure how to do this?
</div>


ISO30: thanks.  I am new to this SSIS stuff. If you can somhow show me how to loop thru records and send out email for those records flagged Email = 1 that would be great since I am not sure  how to do this. Also I guess I would need some kind of  job set-up to run the package say each morning? Also the email messages in body are not status and will need to to reflect data relative to that record. Not sure how to do this?

<div>
<div class="content wysiwyg-content">
Expert: New to SSIS Integration Services Packages.<br />
I have a Execute SQL Task and a Send Mail Task with a precedence constraint between them. I want to know how to create an constraint expression (scalar value?) from the Execute SQL Task query code listed below such that when the query results &nbsp;sets Email = 1 the constraint &nbsp;is satisfied and the Send Mail Task executes. Please show me how to create the Constraint Expression.<br />
<br />
Part of the &quot;Execute SQL Task&quot; &nbsp;query code:<br />
UPDATE TableA<br />
SET Email = 1<br />
WHERE 4 &lt;= datediff(hh, startDate, getdate())<br />
etc ...etc.....<br />
<br />
<br />

</div>
</div>


Expert: New to SSIS Integration Services Packages.
I have a Execute SQL Task and a Send Mail Task with a precedence constraint between them. I want to know how to create an constraint expression (scalar value?) from the Execute SQL Task query code listed below such that when the query results  sets Email = 1 the constraint  is satisfied and the Send Mail Task executes. Please show me how to create the Constraint Expression.

Part of the "Execute SQL Task"  query code:
UPDATE TableA
SET Email = 1
WHERE 4 <= datediff(hh, startDate, getdate())
etc ...etc.....




how do you define/wire a precedence constraint condition between two tasks in an SSIS package

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

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.