Greetings.

I have created a dts package that uses a .Net dll through COM Interop in an
ActiveX script task to generate pdf files from Reporting Services in a
scheduled job. The package works fine when I run it interactively, but can
take exceedingly long or even fail when run from the schedule. I have found
MS KB article 322884
http://support.microsoft.com/default...b;en-us;322884 but am not
sure if that would apply in this instance.

A short description of the job is to grab a list of new invoices for a
client and render then as pdfs for an ftp script to transfer to the client.
When run manually, the pdfs render in about 20 seconds each. When run from
the schedule, they can take 5 - 13 minutes or just fail.

Has anyone else run into any performance issues when trying to use .Net
dll's in scheduled dts packages?

Thanks.

Dale.