Error 0xc020901c: Data Flow Task: While Importing data from an Excel File into SQL Server 2005

Question

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Chris Hurlbut SSCarpal Tunnel Points: 4162 More actions · Answer 1

Hello,

In the project Properties, on the Debugging tab, ensure the Run64BitRunTime is set to false.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Chris Hurlbut (5/29/2015)
Hello,
In the project Properties, on the Debugging tab, ensure the Run64BitRunTime is set to false.

That is an old thread.:-)

I seem to have used Mr. Jack's advice.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

AirJrDan23 Newbie Points: 2 More actions · Answer 3

I fixed mine, check excel file delete any exceeding rows and column from your data.

It is causing to import NULL data in the database, you can simulate this if you import first to a new database.

Thanks,
Danny Balaysoche Jr

Cookies on SQLServerCentral