Monday, July 3, 2017

The application called an interface that was marshalled for a different thread

When an SSIS package is validating a large Excel file (over 600,000 records), I get this error:

'The application called an interface that was marshalled for a different thread'

I was able to resolve the issue by setting the 'Delay Validation' property to True on all objects in the package.