Thanks alot for your help guys. I'll give it a try with using catch and enabling logging to see what I come up with. Will keep you posted. Cheers!

I have checked for logging and there is none. The job that kicks off the DTS is also set as owner SA.

There isn't any error when the DTS runs but...

Thanks for your response. I'm in the admin user group and I've created numerous ETL tasks before. What other information can I provide to give more clarity?