DTS Package runs but gives errors..

[Guest_imported]

Hi,

When I run a DTS package, it gives me the following error.

... DTSRun: Executing... DTSRun OnStart: Create Table [WebPartsTrv].[dbo].[tblGlAcctClass] Step DTSRun OnFinish: Create Table [WebPartsTrv].[dbo].[tblGlAcctClass] Step DTSRun OnStart: Copy Data from tblGlAcctClass to [WebPartsTrv].[dbo].[tblGlAcctClass] Step DTSRun OnError: Copy Data from tblGlAcctClass to [WebPartsTrv].[dbo].[tblGlAcctClass] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file '\\192.168... Process Exit Code 1. The step failed.

The file \\192.168… is the TRAVERSE 2.0 database that runs on Access 2.0

When i run a local DTS package from norhtwind database to my database it works fine. What could be the problem of getting the data from the other machine? Is it to do with the permissions? What permissions I am suppose to set.Please advise in detail.

Best Regards,
Ms. Jasumati

 

[sharonc]

verify that the connection you are using for SQL Agent has access to all stored procedures and tables for the job you are trying to run.