Generate PDFs in SSIS Package

Have had a vb.net app running for years generating PDFs. Trying to convert it to an SSIS package and generate the PDF's inside a script task. The job runs fine on my PC but when I deploy to the server it fails telling me Exception has been thrown by the target of invocation. This same server is where the vb app has been running.

Built the SSIS package in VS 2015 for a SQL 2014 box. The job has been set to run on SQL 2014.

Any thoughts?

Hello,

In general, a common cause of the error “Exception has been thrown by the target of invocation” is if you use the dll that targets one .NET framework version with another. For example, using ceTe.DynamicPDF.20.dll that targets .NET 2.0 in a .NET 4.0 environment or vice versa may result in this error. Check the .NET framework version that your application and make sure you use the appropriate dlls for that .NET environment.

If this error happens with SQL server SSIS package, try registering the dll in GAC.

Thanks,
ceTe Software Support Team.

As it turns out the problem was that the DLL wasn't registered in the GAC. As soon as I did that, the package ran like a champ!