Check source data before processing

hi there,

i wondering best way this. have daily process copy data source destination, simple truncate , reload. there date field in table (transactiondate).

i add check before processing, guess, if max(source transactiondate) > max(destination transaction date), start process, otherwise, nothing.

basically make sure there latest data avalaible before doing anything.

many thanks

---

don

hi don,

my opinion employ precedence constraint here.

so, follows:

1)add package variable (let's can int or bool);

2) drag , drop execute sql task , craft sql query in data in form of 1 or 0 based on whether max(source transactiondate) > max(destination transaction date);

3) add dft load, connect #2 , change using precedence constraint check value of variable returned (say of query gave 0 not proceed, proceed otherwise).

i give blog post read on how mechanics when dealing precedence constraints:

http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

---

arthur my blog

SQL Server  >  SQL Server Integration Services