Re: DTS to merge Excel files

#1

I haven't tried it but you obviously do not like the idea of a macro so.
There is no facility of which I know that would do the equivalent of COPY
a.txt + B.txt C.txt.

You would need to write the header into one cell in Excel in your first
pump.
Excel default is to append so your data should follow underneath in the send
pump.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Cesar Altamirano" <cesaralt (AT) viabcp (DOT) com> wrote

Quote:

Hi,
We have a DTS to create an excel file from a select statement,
all it is ok, until we have to add an elaborated header to each
Excel file created. To create a macro would be very cumbersome
to maintain. then we decided to create an Excel file with only the
header to insert.
How Can we do that in a DTS package?, an ActiveX Script could be
a solution.
Does anybody have some example to do this.
Thanks for any help

Regards,
Cesar Altamirano.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS to merge Excel files

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS to merge Excel files - 08-04-2004 , 11:55 PM