SQL Server Performance Forum – Threads Archive

Random Fails of DTS

Hi,
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!
sudha

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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
sudha

]]>