Connection Error While Running Simple ETL Process With Excel using SSIS

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:

   

3. Click on Configuration properties-> Debugging

   

4. Set Run64BitRuntime property to false.

   

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

Cheers!!