Phil,

this probably is harder to describe by writing than showing. The SQL for the OLE DB Source is a variable (not using expressions just hard coded) AS

SELECT ID ,Description FROM MyTable WHERE LastUpdatedDate >= '[DateChanged]'

Now there is a task prior to this that updates the value of that variable just prior to execution. SO when the package starts I guess it validates against the value in the variable at start up, then when it starts to execute it executes the code that we retrieve from a table that contains SQL statements. I have not checked what the sql is changed to at run time by setting break point but have checked and it should be set to the same value it started as! (Please dont ask why - I am not the author of the work)

I have checked the table where we store the sql statements and the variable should be updated to the same value as it has before the package is run (Will check this ).

Oddly run through BIDS this will not work ever, even if you disable the step that updates the variable - it just fails. Run through a SQL Agent job (not run as 32 bit mode) and the package runs, loads data and completes

E