fax PDF

We have a process that takes XML files and split them into pdf's. These
files then based upon a field in a table need to be faxed. The fax info is
stored in a SQL table. The process needs to insert into the pdf control
characters for faxing. Then this newly created file needs to be picked up by
RightFax to be sent out.
Any suggestions on how this can be done.That process is implement within SQL Server?
Do you need to implement faxing inside SQL as well?
I would suggest writing a custom application outside sql in C# , VB.NET, C++
or whatever language.
Is rightFax a COM based product? If it is you could use sp_OACreate to
create OLE object and pass in pdf file path. But that would be asking for
trouble, like I said you're better off with your own solution.
"Hoosbruin" <Hoosbruin@.Kconline.com> wrote in message
news:X5OdnTd-zqDx2KLfRVn-ug@.kconline.com...
> We have a process that takes XML files and split them into pdf's. These
> files then based upon a field in a table need to be faxed. The fax info is
> stored in a SQL table. The process needs to insert into the pdf control
> characters for faxing. Then this newly created file needs to be picked up
by
> RightFax to be sent out.
>
> Any suggestions on how this can be done.
>sql