The thread for the SSIS Bulk Insert task is already running. ( 0xC020203E )

I have just upgraded from the June Community Technology Project to the
September one and I have been having loads of problems with all my SSIS
Projects since. One of the biggest is the my for each loop container
which loops around a series of csv files and puts them into a data flow
task. The problem is after running the first csv file through the Data
Flow Task I get this error:

Error: 0xC020203E at Data Flow Task, Export To Data Staging [1705]: The
thread for the SSIS Bulk Insert task is already running.
Error: 0xC0047019 at Data Flow Task, DTS.Pipeline: component "Export To
Data Staging" (1705) failed the prepare phase and returned error code
0xC020203E.

So it looks like it is not closing down the first Data Flow Task so it
cannot start the second one. The last part of my Data Flow Task is to
insert into a table which is happening so I know it is completing the
first one!

Is Anyone else having this problem? I seen some one else post about
this but no one has replied.

I'm getting really desperate

Thanks in advance

Denver

Hello Denver,

I have not seen this error even when I was running the September CTP. I
am now running RTM. If you could send me a sample that fails for you and
a rebuild script i could test at my end for you.

i am also not sure what your package looks like as the error suggests a Data
Flow task AND a data Flow task? are they both trying to use the same file
at the same time?

Allan

I have just upgraded from the June Community Technology Project to the
September one and I have been having loads of problems with all my
SSIS Projects since. One of the biggest is the my for each loop
container which loops around a series of csv files and puts them into
a data flow task. The problem is after running the first csv file
through the Data Flow Task I get this error:

Error: 0xC020203E at Data Flow Task, Export To Data Staging [1705]:
The
thread for the SSIS Bulk Insert task is already running.
Error: 0xC0047019 at Data Flow Task, DTS.Pipeline: component "Export
To
Data Staging" (1705) failed the prepare phase and returned error code
0xC020203E.
So it looks like it is not closing down the first Data Flow Task so it
cannot start the second one. The last part of my Data Flow Task is to
insert into a table which is happening so I know it is completing the
first one!

Is Anyone else having this problem? I seen some one else post about
this but no one has replied.

I'm getting really desperate

Thanks in advance

Denver