May 12, 2014 at 10:25 am
I will try to explain this accurately. I have a for each loop using a foreach file enumerator. It starts with a file directory and assigns each item in the directory to a variable. If the item is a file with .xml extension, it processes a data flow task. The source is the XML file, then a multicast with four SQL Server 2012 table destinations. It always inserts 993 rows into each table, then appears to be processing fine on the SSIS side, but in fact the table counts always stay at 993. I was inserting to one database table that was 663 columns but divided that into 4 tables. The datatypes are all nvarchar(128) in each table for each column.
Can somebody please tell me why:
only 993 rows get inserted?
SSIS appears to be processing the inserts when in fact it isnt?
What I can do to get it to work?
Thanks.
Karen
May 12, 2014 at 2:33 pm
Does the package finish?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2014 at 9:36 am
If I run it long enough it finishes.
May 13, 2014 at 10:22 am
How many rows do you expect?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply