Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
veena19
Starting Member
1 Post |
 Posted - 2011-08-28 : 13:50:47
|
| how to create SSIS package to send Fax using RightFaxI need to create a nightly job such that it populates a word template with the values from Sql Server database and Fax and email that document using RightFax |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-08-28 : 15:34:06
|
| I believe they have documented the programming interface in the client help files. If not, search their website for that documentation - which is fairly clear on how to use the API.Then, all you should need to do is install the Rightfax client on the server where you will be running SSIS - and then you can call the API from within a script task. There is another task you can use - cannot recall what it is called, but it is used to execute a process.You will also need Word installed on the server - and that might cause some issues. If I remember correctly, merging in Word requires an active desktop environment which may not work from within SSIS.Jeff |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-29 : 00:19:22
|
| for running this nightly,create a job in sql agent to call this package and schedule it to be executed nightly.Another way to call API is to use Execute process task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-08-29 : 17:31:16
|
| Execute Process Task - that is the one I was thinking of...thanks visakh16 ;)Jeff |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-30 : 09:46:52
|
| No probs...you're welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
RightFax & SSIS