Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Msg 4701, Level 16 trying to truncate table through Linked Server February 2, 2021
  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
  • Msg 8115, Level 16 Arithmetic overflow November 4, 2020
  • SQL Server Columnstore Index Performance Benefits October 6, 2020
May 2017
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr   Jun »

Day: May 22, 2017

SSIS Error Code: 0xC020801C

If you have ever tried to run or create a SSIS extract package that exports to Excel, you may run into the error below:

[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.

Continue reading SSIS Error Code: 0xC020801C

Posted on May 22, 2017May 21, 2017Categories Hints and TipsTags 0x00000000, 0x80040154, 0xC020801C, Connection Manager, excel, ssisLeave a comment on SSIS Error Code: 0xC020801C
Create a website or blog at WordPress.com