SSIS Package with Excel Destination is NOT RUNNING From SQL Job

• Senthilkumar-456461

  SSC-Addicted

  Points: 491

  More actions

  April 11, 2008 at 3:39 am

  #121393

  Hello,

  I have created a SSIS package which is getting data from SQL Server table to Excel File.

  Step 1 : using Oledb to get records.

  Step 2 : created Excel Connection

  Step 3 : Configured the Excel File Path using variables.

  When try to run from BIDS it is running fine.

  But

  It is not running when try to run from SQL JOB.

  The following Error i got:

  : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ::: component "Excel Destination" (588) failed validation and returned error code 0xC020801C. ::: One or more component failed validation. ::: There were errors during task validation. ::

  Kindly give solution ASAP.

  Thanks

  Thiru[/size]

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  April 12, 2008 at 6:15 pm

  #801838

  Make sure that SQL Server Agent service account has permissions to the location of the Excel file.

  Also, here are two links that could help:

  http://support.microsoft.com/kb/918760

  http://support.microsoft.com/kb/933835