I would like to use DTS to read from a SQL table the name address and
fax # and substitute these values into a Word template and fax this
resultant document.

I need to do this everyday several times a day with the DTS package
constantly polling the SQL table and faxing the contents.

Please advise what is the best way to setup this scenario can I call
any Fax activeX components from a ActiveX task please advise.

Thanks
Simon

Yes you can call an ActiveX component inside DTS but to me this does not
sound like a DTS scenario. You would purely be using DTS to serve a rowset
to a word document.

Word can do that by itself can't it?
Can you not automate Word?
Does your fax sotware have scheduling and perhaps an object model?


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote

Wouldn't be better to build a small VB app, using a Fax API instead?
We used ZetaFax, and used their Object model in out VB code.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote