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

  • 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.