Have you checked all the TEMP folders in the system where SQL SERVER is installed ?

Try to create a blank DTS ( no task or connection ) and schedule i...

This issue may occur if the

%SystemRoot%\Temp

or

%user%\Documents & Settings\Temp

folder on the server contains more than 65,535 files. I was getting the error...

This problem is resolved. I will post the resolution process shortly

It seems that almost nobody is aware about the root cause & solution of the Error string: The file exists even in this largest community of SQL Server professionals....

Getting the error in step 2 itself if you look at the picture when input file is getting loaded using tranformation task. So I assume problem is not related to...

1) Could be a issue. but input parameter file size is very small (2-4KB Max). Also got the error when job is scheduled well after the file is transferred (...

Please read the post no. 3 from top where I have mentioned the functionality in detail. An image of DTS is also attached.

Hi Timothy,

I have checked with the help of DBA for both SQL Agent a/c & my personal a/c. DTS is running fine whenever i am running it manually by clicking...

Dose anyone has any answer ?

FYI This DTS jobs are running fine earlier. But few days back the SQL agent account has been changed and stopped working and showing the mentioned error message. Not sure...

Please find the attached pic of the DTS.

Functionality -

----------------

1) Truncate all the temporary tables at starting point of the execution

2) Source file path is given of the CSV file which...

Great !!

Works Perfectly Fine. But showing a error message "Error Source= Microsoft VBScript runtime error Error Description: File not found". Not Sure why !!!

I have pasted the whole...

Ya I can create a DTS package and can schedule it using SQL Agent Job. But my question how can I load dynamic files as stated above

No. But if you think that we can crack using a file list then I will ask them to provide one