Here's an idea try recreating the project, and make sure that Owner is one who has permissions to run the package, preferable the SERVER\Administrator. Otherwise I like the IDEA of:

DTSRun...

That would be good in a normal world but when your talking about a DATA Warehouse and a Half dozen or more DTS Packages, on top of 100's of data...

You woudn't happen to have any examples of this would ya? Thanks. I only have one data source. (text file)

This is what I have so far but when I run it it deletes all the records. What am I doing wrong

DELETE

FROM Customers

WHERE Customers.CUSTID IN

...