Hi,
I have a DTS package which has couple of sql tasks. The SQL query is working fine when i run it manually but when i schedule it, its not picking the latest data from the database. I think it is being cached somewhere.
how to resolve this issue?
Thanks...