MS SQL Server DTS - SSIS - Export to Excel

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS - Export to Excel

Pat

2006-03-31, 1:28 pm

I am exporting two different views to the same spreadsheet but different
sheets. The first export works fine but the second creates the second
worksheet with the same headings as the first. Both exports are created
using the wizard so they are in different packages.

Anybody tried this successfully?

Pat

2006-03-31, 8:26 pm

Nevermind, stupid error.

"Pat" wrote:

> I am exporting two different views to the same spreadsheet but different
> sheets. The first export works fine but the second creates the second
> worksheet with the same headings as the first. Both exports are created
> using the wizard so they are in different packages.
>
> Anybody tried this successfully?

Sponsored Links