I was having an issue of being able to run a package that prints in BIDS but not as a SQL Server Agent job.
Even though I sent everything as run as 32 bit.
Finally tried this.
used this application to print via command line in SSIS Script Task http://www.coolutils.com/TotalPDFPrinterX
Imports SystemImports System.DataImports System.MathImports Microsoft.SqlServer.Dts.RuntimeImports System.ComponentModelImports System.DiagnosticsImports System.IO
Process.Start(
System.Threading.Thread.Sleep(5000)
"C:\Program Files (x86)\Total PDF PrinterX\PDFPrinterX.exe", Chr(34) + complaint_folder + "\*.pdf" + Chr(34) + "-p" + Dts.Variables("varPrinterName").Value.ToString)
System.Threading.Thread.Sleep(5000)
Dts.TaskResult = ScriptResults.SuccessJob Tye (SQL Server Agent)
Operating System (CmdExec)
----------------------------------
"D:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /DECRYPT "password" /FILE "D:\PRODUCTION_FOLDER\DEPLOYED_PACKAGES\PROD\RegulatoryPrint3.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
Showing posts with label ssis. Show all posts
Showing posts with label ssis. Show all posts
Monday, December 19, 2011
Tuesday, November 29, 2011
VS2008 Integration Services Project error: Failed to save package file .... with error 0x8002801D "Library not registered."
run
regsvr32 msxml3.dll
and
regsvr32 msxml6.dll
Get message saying dll regestered.
SSIS works fine
regsvr32 msxml3.dll
and
regsvr32 msxml6.dll
Get message saying dll regestered.
SSIS works fine
Subscribe to:
Posts (Atom)