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

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