SSIS table dump to Excel 1

[kermitforney]

What I have is a simple SSIS package that I am using to run a simple SELECT statement that places the result set into an Excel spread sheet.

I need for it to pull records by category with an empty record in between each Category on the spreadsheet. So, basically I have tried to use Named Ranges, but they just overwrite over themselves.

Is there any other way?

Ex. Sample Pull

Toy, Price
Ball, $1.00
Horse, $2.00
Ball, $1.00
Horse, $2.00

Resulting Excel Output

Ball, $1.00
Ball, $1.00
(include this empty row space)
Horse, $2.00
Horse, $2.00

 

[simian101]

I would just order your query by Toy so that it will be in order when you get to Excel.

Then, use the subtotal feature in Excel or a VBA program to to add a line between each one.

Simi