Random Fails of DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Random Fails of DTS

I have a DTS package that loads my tables from csv file. I works fine in my DEV/QA environments. But in Production environment, it fails on and off say 20% of the time it fails. with either of the 2 messages:
1. Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: The process cannot access the file because it is being used by another process.
2. Microsoft Data Transformation Services (DTS) Package (8007000e): Not enough storage is available to complete this operation. I have sufficient RAM(2GB) and 80GB HDD space
Any solutions/clues would be of great help!
Thanks a ton!
1. Ensure the source file (.CSV) is not in use by Excel or any other application. 2. What are the memory settings on the SQL Server>
It means the SQL server doesn;t have required memory in order to complete the operation. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
csv file is not used by any other process. Thats sure.
what memory you are refering to here? as i had mentioned i have 80GB HDD and 2 GB RAM