开发者

Data flow task not getting completed and flat file generated is in locked state

开发者 https://www.devze.com 2022-12-09 02:07 出处：网络

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

相关专题：ssis

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 t开发者_StackOverflowhe 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.

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.

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?