Problem scheduling SSIS package with Excel connection

• Jason Coleman

  SSCrazy

  Points: 2187

  More actions

  April 2, 2007 at 6:25 am

  #116772

  I have an SSIS package that uses an excel connection to drag data from an excel workbook. If I run the package inside VS it works fine. Executing the package within the sql agent fails every time however.

  The error I receive is that the command line is incorrect. Disabling the step with the excel connection in, and rescheduling the package makes it work fine, therefore it is due to the excel connection.

  the command line that I have is...

  /FILE "C:\APPS\SQLIMPORT\WHITFORD_DATA_CONSOLIDATION\WHITFORD_DATA_CONSOLIDATION\bin\PCK280_BRZ_DATA_IMPORT_UPDATE.dtsx" /CONNECTION "Excel Connection Manager";"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\APPS\SQLIMPORT\DATA\brzsalesexport.xls;Extended Properties=""EXCEL 8.0;HDR=YES"";" /CONNECTION USASQLCLUST;"Data Source=USASQLCLUST;Integrated Security=SSPI;Connect Timeout=30;" /CONNECTION "USASQLCLUST.ERP-Dataconsolidation";"Data Source=USASQLCLUST;Initial Catalog=ERP-Dataconsolidation;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

   

  But I cant see any issues with this..???? Can anyone help me out??

   

  Thx

• chrisbarba-570443

  SSC Enthusiast

  Points: 177

  More actions

  December 28, 2009 at 1:28 pm

  #1096809

  Are you running in a 64-bit environment?

  Excel only works in a 32-bit environment (VS is 32bit)