Subject: SQL Server Error
Posted By: Jane Post Date: 2/9/2004 7:31:46 PM
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
 
 
   Topic

Go to topic 9586

Return to index page 952
Return to index page 951
Return to index page 950
Return to index page 949
Return to index page 948
Return to index page 947
Return to index page 946
Return to index page 945
Return to index page 944
Return to index page 943