November 3, 2009 at 2:37 pm
hello,
yes that is a strange subject, but my SSIS package consistently dumps data starting on the 443th row in a FOR EACH loop container. :ermm: it could be one row or 1000 it always dumps the data start on the 443th row. Have you ever seen anything like this. what could cause this ?!?!
Thanks!
November 3, 2009 at 2:38 pm
November 3, 2009 at 2:41 pm
I mean it populates rows in the Excel file via a Data Flow Task which contains an Ole DB source then a Data Conversion Task and then the Excel destination . the Excel file is created from a template that has all the column headers I need.
November 3, 2009 at 2:44 pm
So all of this is inside a data flow and the data flow is inside a for each loop?
Why the for each loop?
November 3, 2009 at 2:46 pm
No - it should not do that. For some reason, the Excel driver thinks that there is data in the spreadsheet in the preceding rows.
Try recreating the template from File/New in Excel and then just copying in the headings you want to test this hypothesis.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 3, 2009 at 2:49 pm
yes all that in a Data Flow in the for each loop. reason being (could be bad design) I have to loop through each task, then find all subtasks, push them out to an Excel file and then email each excel file to the person reponsible for that task and subtasks..
November 3, 2009 at 2:51 pm
ok that did the trick, thank you! I recreated the xl file from scratch and now it is working beautifully!
November 3, 2009 at 2:52 pm
That makes sense. I was just wondering if there was some funky looping logic that we needed to worry about.
I would go w/ Phil's suggestion for now. Have you considered allowing SSIS to create the column headers instead of using the template method?
November 3, 2009 at 3:09 pm
Yes I have tried it and ran into too many issues which was the 443th issue, I thought it was not clearing the Sheet when actually it was but the data was on the 443th row :-D. SSCommitted (sleepy head picture) suggested the delete then copy template which suits my need! Appreciate you folks help a lot!
November 3, 2009 at 3:20 pm
yosiasz (11/3/2009)
Yes I have tried it and ran into too many issues which was the 443th issue, I thought it was not clearing the Sheet when actually it was but the data was on the 443th row :-D. SSCommitted (sleepy head picture) suggested the delete then copy template which suits my need! Appreciate you folks help a lot!
My name's Phil you wally 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply