Thanks!

I have emailed the DBAs already and they are still looking for it but based on their initial response, the files in there have the correct naming convention. They sent me the file as well and I tested it using dev and they all work fine.

When they run it in prod everything fails again - even the one file they are trying to load.

While waiting for their findings, I was just thinking - could there possibly be a problem with the integration services being of different version perhaps between the two servers that might be causing the problem? Something like a problem in the framework or some kind of that sort - I'm pretty much not familiar with it so I was just guessing.

Anyway, you are right - it is really difficult to troubleshoot without the actual look on the data passing in and out in the package especially when everything else works fine in dev.