Home Forums Data Warehousing Data Transformation Services (DTS) Error 0xc020901c: Data Flow Task: While Importing data from an Excel File into SQL Server 2005 RE: Error 0xc020901c: Data Flow Task: While Importing data from an Excel File into SQL Server 2005
shahrouz.ebadian
Valued Member
Points: 58
More actions
July 5, 2011 at 1:58 pm
#1348559
2 years later but same thing happened to me. Had to go from Excel ->Access -> SQL.
Directly from Excel to SQL did not work for the life of me. Tried all the hacks including the registry, getting column length to max. No idea why.