[Fix] - ErrorC0047072

Wikitechy | 1000 Views | sql server | 08 Jun 2016

 

Scenario :

  • Executing a SSIS package ended up with the above specified error.  

Reason for the error :

  • The error happens because of memory cache of the SSIS package that is caused due to more than one lookup for a same table.

Fix :

  • Disable the memory caching for the lookups sharing the same data.


Applies to sqlserver version : 

  • SQL Server 1.1 (16 bit)
  • SQL Server 4.2A (16 bit)
  • SQL Server 4.2B (16 bit)
  • SQL Server 4.21a
  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 7.0 OLAP Tools
  • SQL Server 2000
  • SQL Server 2000 64-bit Edition
  • SQL Server 2005
  • SQL Server 2008
  • Azure SQL DB
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

Related Tags:

  • MS SQL Server :: Lookup Error Redirection Problem
  • SSIS DTS.Pipeline To MSAccess Databse
  • Lookup Error Redirection
  • MS SQL Server :: Lookup Error With Code 0xC0047072
  • Error: 0xC0047072 at Import to DTS.Pipeline:




Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise