Thom, if that's the case, you are right.

But for the examples provided, I can't see how it's required (excepting, possibly, the change in cost price – though any half-decent application...

I mean by running one or more queries which look for validation issues & passing the results of those queries to sp_send_dbmail.

There are many ways of doing it. Here...

I'm not a fan of triggers, so my initial thought would be to create a SQL Agent job which runs periodically (hourly? daily?), looking at all rows in the table...

• Create a variable expression to hold the entire SQL statement.
• Add the lookup to the dataflow.
• At the Control Flow level, get properties for the dataflow and go into...

while it's slightly off topic, I worked with a  team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"...

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS 2005 Express. The new server is Windows 2008 R2 SP1 and has SQL 2008 R2...

I came...

Preferred option would be to make the Java app perform the notification itself.

Use a non-locking record count technique, such as

SELECT TotRows = SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('schemaname.tablename')
...

Thanks all. Here is the SSIS expression for those who only need to use SSIS, DATEADD("hh",17,(DT_DBTIMESTAMP) ( (DT_STR,30,1252) (DT_DBDATE) (DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate()) ) )...

Well done on providing the DDL for the table.

Would you also be able to provide some sample data, along with desired results, based on that sample data?

The sample data should...

I don't think that this is...

I need my child packages to run in parallel (multi-threading)... They're loading lots of data and I can't wait for one to finish before starting the other. I've tried...

The Agent service account.

Don't think you can. Precedence constraints are the answer – what is the reason for you not using them?

Thanks, Jeff. The date processing capabilities in T-SQL are significantly more powerful than those built in to SSIS (though, of course, SSIS has native access to .NET libraries through C#...