none
Scheduled Job Active X Issue

    Question

  • When I try to run a package as a scheduled job in SQL I am getting "Cannot create ActiveX component" error.  It runs fine when I run it manually.Have you run into this?  If so, can you point me to a solution? 

    Monday, October 28, 2013 7:15 PM

Answers

  • The error text your are giving us perhaps is not exactly what it is but the issue must stem from you running the SSIS step using the Agent's account which happened to have tightened security.

    The issue gets resolved by using a proxy account as follows: http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/


    Arthur My Blog

    Monday, October 28, 2013 7:40 PM
    Moderator