Problem with my OLDB source (Error with the AquireConnection )

Rami Frikha 91 Reputation points
2020-09-04T16:40:00.673+00:00

Greeting all ,

while the daily refresh of my data source , i found this error in my SSIS , anyone faced such thing please ?

22722-microsoftteams-image-2.png

Thanks in advance .

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-07T02:16:19.893+00:00

    Hi Rami,

    1.Please try to set Delay Validation as True in ssis package.
    2.If the first step does not work, please delete the OLEDB connection manager and create new connection manager.

    Best Regards,
    Mona

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

  2. Farhan Ahmed 1 Reputation point
    2020-09-07T10:20:58.257+00:00

    make sure that you don't have 32-bit connection for SSIS Package, if yes then you need to set 32-bit runtime as "true" or selected in package execution.

    0 comments