Thank you for quick response.

Regarding BIDS Session, no we set up DTS and its editor on the 2008 instance. I was not aware that there was any method other than that or SSIS.

I am currently working on setting up an SSIS job to run the package in the hope of getting it to run that way.