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

  • Lempster (10/2/2014)


    Koen Verbeeck (10/2/2014)


    Phil Parkin (10/2/2014)


    Does the account executing the package have access (and permission) to the Excel file?

    If it's on a local drive on the server, I would not expect it to be a permissions problem. Or perhaps you know otherwise?

    Does the SQL Server Agent account have permission to all local folders?

    Exactly what I was going to ask!

    Ha! One step ahead of you 😛

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP