> Hello.
> While I found several Excel destination posts similar to mine, I
> didn't see one with my particular issue.
> Within the SSIS designer I have a simple data task with a two
> ForEachLoops. The first foreach will write to my Excel Destination's
> first two columns. The second foreach will correctly write a query
> result to the third column however it writes in the rows below the
> rows that the first column wrote to. I imagine there is a row-lock
> of some sort that the first thread applies to the Excel destination
> and then subsequent threads start at the next set of 'clean' rows.
> This unfortunately makes my Excel document look disjointed and more
> difficult to visually inspect because I would like single complete
> rows written from these two loops. Are there any recommendations
> about Excel write-modes or do I need to refactor my loops into
> possible one loop? Is this an inherent problem with working with
> Excel destinations as opposed to something else?
>
> Any help would be much appreciated.
>

On Jun 14, 9:30 pm, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello reflection,
>
> The two loops are seen as two completely seperate things and therefore the
> action will be an append to the bottom of the sheet. To get every thing
> on the same line I would look to move things into 1 data flow if possible..
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
> > Hello.
> > While I found several Excel destination posts similar to mine, I
> > didn't see one with my particular issue.
> > Within the SSIS designer I have a simple data task with a two
> > ForEachLoops. The first foreach will write to my Excel Destination's
> > first two columns. The second foreach will correctly write a query
> > result to the third column however it writes in the rows below the
> > rows that the first column wrote to. I imagine there is a row-lock
> > of some sort that the first thread applies to the Excel destination
> > and then subsequent threads start at the next set of 'clean' rows.
> > This unfortunately makes my Excel document look disjointed and more
> > difficult to visually inspect because I would like single complete
> > rows written from these two loops. Are there any recommendations
> > about Excel write-modes or do I need to refactor my loops into
> > possible one loop? Is this an inherent problem with working with
> > Excel destinations as opposed to something else?
>
> > Any help would be much appreciated.

On Jun 14, 9:30 pm, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello reflection,
>
> The two loops are seen as two completely seperate things and therefore the
> action will be anappendto the bottom of the sheet. To get every thing
> on the same line I would look to move things into 1 data flow if possible..
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
>
>
> > Hello.
> > While I found severalExceldestinationposts similar to mine, I
> > didn't see one with my particular issue.
> > Within the SSIS designer I have a simple data task with a two
> > ForEachLoops. The first foreach will write to myExcelDestination's
> > first two columns. The second foreach will correctly write a query
> > result to the third column however it writes in the rows below the
> > rows that the first column wrote to. I imagine there is a row-lock
> > of some sort that the first thread applies to theExceldestination
> > and then subsequent threads start at the next set of 'clean' rows.
> > This unfortunately makes myExceldocument look disjointed and more
> > difficult to visually inspect because I would like single complete
> > rows written from these two loops. Are there any recommendations
> > aboutExcelwrite-modes or do I need to refactor my loops into
> > possible one loop? Is this an inherent problem with working with
> >Exceldestinations as opposed to something else?
>
> > Any help would be much appreciated.- Hide quoted text -
>
> - Show quoted text -