Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / Languages / SQL

Connection Error While Running Simple ETL Process With Excel using SSIS

0.00/5 (No votes)
22 Mar 2016CPOL 10.7K  
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager failed with error code 0xC0209303.

Introduction

Running Simple ETL process with Excel using SSIS in Visual Studio, Package throws run time error like connection manager failed with error code 0xC0209303.

What Caused It?

This issue is basically caused by mismatch Visual Studio RUN TIME mode mismatch. If your project is set specifies whether the project should start 64 bit SSIS runtime.

How To Fix It?

In order to fix this issue, please follow the below steps:

  1. Right click on your project, and choose properties
  2. The below screen will be visible:

    Image 1

  3. Click on Configuration properties-> Debugging

    Image 2

  4. Set Run64BitRuntime property to false.

    Image 3

  5. Click on Apply button and re run your package.

Cheers!!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)