Share via

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Fredd Minda 0 Reputation points
2024-01-25T21:07:45.6333333+00:00

I use Sql Server 2016 and Visul Studio 19 With a SQL Server Information Services SSIS package I load an Excel file that is in a shared folder on the NAS If I run the package from Visual Studio I have no problems, but when I run the package deployed on the SQL Server I have these errors: Código de error 0xC020801C DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Código de error: 0xC0202009 Código de error: 0x80004005 Saludos, Fredd

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,346 Reputation points
    2024-01-26T05:27:29.5066667+00:00

    Hi @Fredd Minda,

    Please ensure that the account running SSIS package in agent job has access to ALL folders and files in the path you are accessing.

    You may use a proxy account to run the job which has full permission.

    create-a-sql-server-agent-proxy

    running-a-ssis-package-from-sql-server-agent-using-a-proxy-account

    Regards， Zoe Hui

    ---If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments