Home Forums Data Warehousing Integration Services My SSIS import from Excel package works from my PC, does not from Server RE: My SSIS import from Excel package works from my PC, does not from Server

  • Vic Rauch-303403 (10/1/2014)


    Everything is hard coded, and as simple as possible. I have 5 steps. Empty the SQL table (OperationalData), import from Excel (three step process, The source descriptor, the data conversion, and the Destination descriptor), then empty the Employee SQL table, import from the second Excel spreadsheet using the same (conceptually) three steps (but of course they are their own 3 steps, nothing shared except the concept), and lastly, execute a stored procedure that runs 5 other stored procedures where all the "work" is done on this newly imported data. I'm thinking very straight forward, easy, and it still refuses to work.

    It's not exactly best practice, but are you able to RDP into the server and then run the package there manually in SSDT?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.