dbTalk Databases Forums  

SSIS - Foreach Loop loading several xml files

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS - Foreach Loop loading several xml files in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Drew
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.