Hi All,
Sql server 7.0

We have DTS package which runs evey hour to transfer data from access (.mdb)
file to sql server databases, just some time back it was working fine.. but
now if fails.. below is the error message from view job history
.... DTSRun: Executing... DTSRun OnStart: Copy Data from ohReport to
[BNW].[dbo].[ohReport] Step DTSRun OnError: Copy Data from ohReport to
[BNW].[dbo].[ohReport] 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: -66913278 (FC02FC02) Error string: Disk or network
error. Error source: Microsoft JET Database Engine Help file:
Help context: 5003043 DTSRun OnFinish: Copy Data from ohReport to
[BNW].[dbo].[ohReport] Step DTSRun OnS... Process Exit Code 12. The step
failed.

When i try to run the package manually it runs fine but when i schedule it
fails
I tried pinging to the server where .mdb file is there its replying.

TIA

Hello Abdul,

Running a package interactively and on a schedule are two very different
beasts.

Have a look here

http://support.microsoft.com/?kbid=269074

Allan