I have a SSIS package deployed in 64-bit machine. The package is running fine if there are less number of records to be extracted and written to a file. We are using a data flow task for writing into file. However when we are runnning the package for large data extract, the data flow task is not getting completed and the file is getting locked. Please suggest a solution for this.
views:
37answers:
2
A:
Are you logging the progress of your package? Do you see anything in there? If not, can you log the progress?
If you are writing to a UNC, I would suggest writing locally and then moving the file where you want.
Raj More
2009-10-23 18:26:06
I am not logging the progress. However when I run the package directly, the status of the data flow task is in yellow and it is not getting completed. I have tried both writing to a UNC and locally. In both cases, the issue is occurring
Ravisankar
2009-10-24 03:50:51
I think you should add logging to the package.
Raj More
2009-10-24 10:04:09
If it is yellow, what is shown in the progress tab?
Raj More
2009-10-24 10:05:12
A:
Some debugging directions: Check if you are getting same problem with a different type of target like excel or SQL table. Check which process is using the file currently (use tools like ProcessXP for this) and check if file is showing any contents at any intermediate stage. By the way are you using transactions?
Faiz
2009-10-24 18:46:59