I can't get the Source Adapter example mentioned in chapter 14
working. In VS/BIDS after adding the source adapter, setting a
source and going to the Column Mappings tab and pressing OK, I get:
Error at Data Flow Task [Professional SSIS Source Adapter]:
from HRESULT: 0xC0048004 at
Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSExternalMetadataColumnCollection90.get_Item(Object Index) at ...
The exception is being thrown at line 344:
mdc = output.ExternalMetadataColumnCollection[col.ExternalMetadataColumnID];
The col.ExternalMetadataColumnID looks correct - the same as
supplied to the output column when the external column was created.
Has anyone else had this problem?