SSIS “Error HRESULT E_FAIL has been returned from a call to a COM component”

Question

SSIS “Error HRESULT E_FAIL has been returned from a call to a COM component”

hila.bar

SSC Veteran

Points: 264
More actions
December 8, 2015 at 2:45 am

#313734

SQL Server 2012 with SQL Server Data Tools installed on Windows 7. I have a very large SSIS package with many components. A specific Data Flow task throws this error on every modification made.
Message from Event Viewer:
Faulting application name: devenv.exe, version: 10.0.40219.1, time stamp: 0x4d5f2a73
Faulting module name: DTSPipeline.dll, version: 2011.110.3000.0, time stamp: 0x5081c196
Exception code: 0xc0000005
Fault offset: 0x0003849f
Faulting process id: 0x4138
Faulting application start time: 0x01d130ded2d601a2
Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe
Faulting module path: C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTSPipeline.dll
Report Id: 42eddcc7-9cd9-11e5-ae7e-7446a0ae3c09
Any ideas what is going on here??? By the way, tried running the same thing on 2 other machines. Same problem.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 1

hila.bar (12/8/2015)
SQL Server 2012 with SQL Server Data Tools installed on Windows 7. I have a very large SSIS package with many components. A specific Data Flow task throws this error on every modification made.
Message from Event Viewer:
Faulting application name: devenv.exe, version: 10.0.40219.1, time stamp: 0x4d5f2a73
Faulting module name: DTSPipeline.dll, version: 2011.110.3000.0, time stamp: 0x5081c196
Exception code: 0xc0000005
Fault offset: 0x0003849f
Faulting process id: 0x4138
Faulting application start time: 0x01d130ded2d601a2
Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe
Faulting module path: C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTSPipeline.dll
Report Id: 42eddcc7-9cd9-11e5-ae7e-7446a0ae3c09
Any ideas what is going on here??? By the way, tried running the same thing on 2 other machines. Same problem.

First guess would be "Access Denied", have you checked credentials used and file level permissions?

😎

hila.bar SSC Veteran Points: 264 More actions · Answer 2

Found it!!!

Eirikur Eiriksson - Although it had nothing to do with file permissions, but you gave me the idea to look into the XML and XSD files used as the variable default values.

The files were fine, but incompatible with the fields in the data flow.

After modifying to different XML and XSD files, suddenly everything worked...... No more errors.

Thanks!