Hi Viswanadh,

probably best to create a new thread instead of posting on the back of an old one...much more likely to get a response that way...:P

Thanks for the thought - have tried starting again from scratch a couple of time - including removing the driver and reinstalling that !!!

But to no avail...

Thanks for that Paul,

all 32bit, extracting from a system designed by Kerridge, called Kestrel, using the ODBC provided by them - I've taken a read of the white paper but...

That would work, I am just trying to keep everything in one table so I can also store other criteria as to when the package should run - thus allowing...

Thanks for the sharp reply Michael,

I have tried amending the connection manager properties but this didn;t have any effect....I have also tried adding the DSN as a data source in...

Thanks for that Michael...prompted me to take another look and find the problem !!!

I had omitted the backslash in the experssion which is why it wasn;t working...

I had simply ...

Hmm...don't think it is the Connection Property that needs setting - am trying to set the PackageName property of the Execute Package Task by using the experssions to populate the...