DTS running error
Hi, good afternoon
I have a problem cannot solved.
While I running a DTS, it hit an error, but i don't know how to solve an error as this:
Executed as user: BPWHSE\ReplicationUser. ... DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_5 DTSRun OnError: DTSStep_DTSDataPumpTask_4, Error = -2147467259 (80004005) Error string: I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000012080000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'. Error source: Microsoft OLE DB Provider for S... Process Exit Code 3. The step failed.
how to reslove an error as above? Urgent!!!
Thanks
|