I have a dts package that uses a transform data task to import data from a MySQL database to a loading table in sql server 2000. The package runs fine when I run it manually. However when I run it as a scheduled job I get the following

Cannot instantiate Storage Object for source column 6 ('DirLoc') Blob data. Your provider may require that all Blob columns be rightmost in the source result set

I tried moving all the large fields (longtext in MySQL) to the end of my select query but there are quite a few (25) and I keep getting the same error as above but with whichever column is leftmost

Any ideas welcome!