I am extracting Data to an Excel Spreadsheet. I would also like to
auto-print the spreadsheet from DTS. Does DTS have a "print" functionality,
or do I issue the print command in a DOS file or within the Spreadsheet?
Anyone have some ideas they can send my way. We are using Windows Server
2003 with SQL 8.00.

Thanks,
Leslie

I would issue the print command from whatever process DTS returns
control to. You could also do it within DTS itself, using an ActiveX
task to call the Excel application object.

--
David Portas
SQL Server MVP
--

Thank you David,

When you talk of issuing the "print command" are you referring to a DOS
batch command file?

If I were to do this with ActiveX, what would the syntax be? I've never
worked with ActiveX. (I'm a bit of a newbie).

Thanks!
Leslie

"David Portas" wrote: