Wednesday, September 16, 2009

"Exception from HRESULT: 0xC0010014" Foreach Loop Container SSIS

If we create a new Integration Services Project on the servers BI Visual Studio,
chose the Foreach Loop Container,
click edit on it
and click on the three dots on Expressions under Collection we get an error message saying:

"Exception from HRESULT: 0xC0010014".

Resolution:
============================
issue was resolved by registering ‘ForEachFileEnumerator.dll’ using regsvr32.exe:

c:\program files (x86)\microsoft sql server\90\dts\foreachenumerators\ForEachFileEnumerator.dll

As per this link:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8cf03f7d-f170-40db-98fa-af151d5b5269

No comments: