I have a VB6 application running on w2000 pro, both remotely and locally. I do not have access to the source code at this time.

The application is trying to call a DTS package to import data from a text file. This was running fine under SQL 7.x, but when the database was moved to SQL 2000 it quit working. No errors are logged, no messages given. The work around has been to run the DTS package manually from Enterprise Manager; which works correctly.

I modified the DTS package to do just a file copy and it still does not work. It would appear to me to be some sort of application access rights but I can not find any information regarding this.

Does anyone have any thoughts?