Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saiabhiram
Starting Member
17 Posts |
 Posted - 2010-04-26 : 00:35:38
|
| Hello,I am using a File System task that copies files from a working folder to an output flder. Incidentally in SSIS, these files are written to the working folder by a dataflow task. Once it is done, the file system task copies the files from the working folder to output folder. When I do this, I get an error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\SSISData\OutputAutoCbaTran(yyyy)(mm)(dd).txt' because it is being used by another process.".Please help. Any help would be greatly appreciated :) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-26 : 00:47:33
|
| how are you copying the files inside data flow task? is it using a script task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
saiabhiram
Starting Member
17 Posts |
Posted - 2010-04-26 : 01:28:16
|
| no using a oldeb destination and copying the files to a flat file destination |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-26 : 01:55:54
|
| is the file system task happening after data flow task. what have you set for precedence constraint?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
File System Task