78 ErrorC0047072 - wikitechy.com

[Fix] - ErrorC0047072

Wikitechy | 3195 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:

[Fix] - Error Codes - 1071607685 DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE

[fix]-Cannot build cube

World's No 1 Animated self learning Website with Informative tutorials explaining the code and the choices behind it all.

Workshop

Bug Bounty
Webinar

Join our Community

Advertise

<