ProfSSISSourceAdapter problems

jdu · February 8th, 2006, 09:46 PM

Hi,

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:

Code:

Error at Data Flow Task [Professional SSIS Source Adapter[87]]:
System.Runtime.InteropServices.COMException(0xC0048004): Exception
from HRESULT: 0xC0048004 at
Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSExternalMetadataColumnCollection90.get_Item(Object Index) at ...

The exception is being thrown at line 344:

Code:

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?

Martin_Bishop · May 17th, 2006, 02:16 AM

Hello Jdu,
if you change the row:

Code:

mdc = output.ExternalMetadataColumnCollection[col.ExternalMetadataColumnID];

to next one

Code:

mdc = output.ExternalMetadataColumnCollection.FindObjectByID(col.ExternalMetadataColumnID);

and add to if clause next one

Code:

 "mdc == null ||"

all will be OK.