SSIS - Foreach Loop loading several xml files -
10-27-2005
, 03:04 PM
qI have found a weird problem.
I have a directoty of xml files that I want to load using a Data Flow
package, so I put the Data Flow package inside of a Foreach Loop... and
everything works great... for the first one. The second xml file causes a
weird error:
Information: 0x40043006 at Data Flow With Standardization, DTS.Pipeline:
Prepare for Execute phase is beginning.
Error: 0xC020203E at Data Flow With Standardization, SQL Server Destination
[5303]: The thread for the SSIS Bulk Insert task is already running.
Error: 0xC0047019 at Data Flow With Standardization, DTS.Pipeline: component
"SQL Server Destination" (5303) failed the prepare phase and returned error
code 0xC020203E.
Information: 0x40043009 at Data Flow With Standardization, DTS.Pipeline:
Cleanup phase is beginning. |