Click here to Skip to main content
15,038,237 members
Articles / Database Development / SQL Server / SQL Server 2008
Technical Blog
Posted 26 Jan 2013


3 bookmarked

How to Solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

Rate me:
Please Sign up or sign in to vote.
4.88/5 (16 votes)
26 Jan 2013CPOL1 min read
This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017


SSIS is one of the best ETL tools available in the market and it can load a large amount of data from any heterogeneous data source whether structured, unstructured, application, cloud or real-time data. This post discusses the solution of a common problem that usually arises while importing data from Excel data source.


Beginners, while doing the extract, face some weird issues, which seem very fuzzy to solve at first. Such a problem is while doing extract from Excel data source. After running, the application shows error:

at Package, Connection manager “Excel Connection Manager”: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.Error: 0xC020801C at Data Flow Task — Excel File, Excel Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.Error: 0xC0047017 at Data Flow Task — Excel File, SSIS.Pipeline: component “Excel Source” (1) failed validation and returned error code 0xC020801C.Error: 0xC004700C at Data Flow Task — Excel File, SSIS.Pipeline: One or more component failed validation.

And the extraction failed.

The reason for this run-time error is that Excel does not have a 64-bit driver which is selected by default in SSIS running on 64bit OS. So, the solution is also hidden behind the reason, change the driver from default and you are good to go. Steps to solve the issue are given below.

Step 1

Navigate to Project-> [PROJECT_NAME] Properties.


Step 2

Navigate to “Debugging” option from left panel and from Right panel, change Run64BitRuntime value to false.


That’s it!! Keep extracting!!

Image 3 Image 4


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


About the Author

Shahriar Iqbal Chowdhury/Galib
Chief Technology Officer
Bangladesh Bangladesh
I am a Software Engineer and Microsoft .NET technology enthusiast. Professionally I worked on several business domains and on diverse platforms. I love to learn and share new .net technology and my experience I gather in my engineering career. You can find me from here

Personal Site
Personal Blog
FB MS enthusiasts group
About Me

Comments and Discussions

QuestionIssue resolved Pin
Member 1532714817-Aug-21 5:45
MemberMember 1532714817-Aug-21 5:45 
Questiongratitude Pin
Rumana S15-Jun-21 5:59
MemberRumana S15-Jun-21 5:59 
PraiseHow to Solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017 Pin
Member 1352472616-Nov-17 1:17
MemberMember 1352472616-Nov-17 1:17 
Praisehelp Pin
Rodney Rinaldi10-Nov-16 1:58
MemberRodney Rinaldi10-Nov-16 1:58 
QuestionOMG ... Really? Pin
Member 1228682325-Jan-16 11:19
MemberMember 1228682325-Jan-16 11:19 
PraiseThank you!!! Pin
Member 1223473629-Dec-15 8:38
MemberMember 1223473629-Dec-15 8:38 
GeneralRe: Thank you!!! Pin
Shahriar Iqbal Chowdhury/Galib29-Dec-15 20:18
professionalShahriar Iqbal Chowdhury/Galib29-Dec-15 20:18 
PraiseThank you for this help Pin
shmim23-Nov-15 2:00
Membershmim23-Nov-15 2:00 
QuestionThanks for saving my day Pin
Manish Kumar Mawatwal21-Jun-15 0:09
MemberManish Kumar Mawatwal21-Jun-15 0:09 
AnswerRe: Thanks for saving my day Pin
MarcusCole68333-Nov-15 6:25
professionalMarcusCole68333-Nov-15 6:25 
QuestionSQL Server 2005 Import Errors Pin
MikeJKemp14-May-15 1:24
MemberMikeJKemp14-May-15 1:24 
QuestionHow to solve SSIS error code 0xC020801C/0xC004700C/0xC0047017 Pin
Malidu15-Feb-15 3:31
MemberMalidu15-Feb-15 3:31 
QuestionSuberb Iqbal Pin
Beauty Keshri Shah20-Nov-14 0:05
professionalBeauty Keshri Shah20-Nov-14 0:05 
AnswerRe: Suberb Iqbal Pin
Shahriar Iqbal Chowdhury/Galib20-Nov-14 19:18
professionalShahriar Iqbal Chowdhury/Galib20-Nov-14 19:18 
QuestionGreat article Pin
rjillellamudi5-Dec-13 8:03
Memberrjillellamudi5-Dec-13 8:03 
QuestionGreat Pin
ToBecomeDay23-Oct-13 18:00
MemberToBecomeDay23-Oct-13 18:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.