SQL Server Performance Forum – Threads Archive
Random Fails of DTSHi,
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