Deployed SSIS package is not working.

• Maheshsoft1987

  SSC-Addicted

  Points: 464

  More actions

  September 9, 2011 at 10:55 am

  #256973

  Hi,

  I have a SSIS package which insert mssql table records in excel destination.

  I have deloyed this packages on live DBServer and my excel file destination is development DBServer. because I don't have msoffice on my live DBServer. I have set everything perfect(eg. I have shared excel folder and given full rights also given network path in package excel connection) but package is not executing given excel file validating error. Please suggest me.

  Thanks in advance.

  Mahesh.

• NJ-DBA

  SSChampion

  Points: 13832

  More actions

  September 9, 2011 at 1:09 pm

  #1379486

  Please post the entire error message.

• SQLMD

  Right there with Babe

  Points: 764

  More actions

  September 9, 2011 at 2:48 pm

  #1379515

  Is the Server 64bit? I haven't tried it in a while, but I know when SSIS first came out you couldn't export to Excel on a 64bit install.