Issue with Server DTS package executed via a web app

• stephen.ngqwebo

  SSC Enthusiast

  Points: 118

  More actions

  June 11, 2012 at 2:20 am

  #257431

  Hi,

  I have inheritted a DTS package that imports an excel file into a SQL 2005 db, executed via a .net web application. This works fine with all clients except for one new user in the company. However when the user is logged onto the application using their credentials but on a colleague's machine, everything works fine. When the user imports the file on their machine, the error "There was an error running the DTS package" is thrown. Anyone who can assist in this regard? I am thinking of installing SQL 2005 service pack 4 on the client machine but this should not be necessary as the DTS package resides on a server.

  Your help much appreciated.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  June 11, 2012 at 2:37 am

  #1499201

  Do you mean DTS or SSIS?

  ---

• stephen.ngqwebo

  SSC Enthusiast

  Points: 118

  More actions

  June 11, 2012 at 2:59 am

  #1499204

  It is a DTS package.