Generate pdf of DTS Job.

[travisbrown]

I am outputting a scheduled job nightly. Right now I have it set up to ftp a textfile to a network drive. Anyone know a good way to automatically generate a pdf from this report? I'm not sure how accommodating the server admin will be to installing components or apps, but I'll take a stab.

 

[DrSql]

Here is a suggestion. You might need to buy some third party tool that convert txt2pdf. Then as a last step of your DTS package you can use "Execute Process Task" will give you an option to execute a executable. Hope this helps you out, or you can write a vb or dos script to print to Adobe Acrobat Printer. That get installed when you insatll full version of Adobe Acrobat.

Dr.Sql
Good Luck.