SQL Server Performance Forum – Threads Archive

printing to different ip based printers

I’m being asked to create a scheduled DTS package that will print data to printers, I would like to seek some assistance on how I would be able to print to different printers based on ip address. IP address can be hardcoded to the package. I’ll just copy and recreate another package to point to another IP address. Any help will be greatly appreciated! Thanks.

---

or I can add 3 or more printers using Add Printer wizard but how do I tell the DTS package to use a specific printer and especially that the DTS package might be schedule at the same time? I don’t think I can use object.SetDefaultPrinter(strPrinterName) because it might affect the other running DTS package.

---

]]>