I'm loading a series of files dynamically to corresponding tables. When I run, I get the following error.
Error: System.Runtime.InteropServices.COMException (0xC0010014): Exception from HRESULT: 0xC0010014
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerFlatFileColumns100.Remove(Object Key)
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.DynamicFlatFileSource.RemoveColumn(String colName)
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.DynamicSourceComponent.FilterSource(IList columns)
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.DynamicFlatFileSource._SetDynamicColumns()
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.DynamicFlatFileSource.Setup()
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.DynamicSetup._Setup(Boolean thunk)
at CozyRoc.SqlServer.SSIS.DataFlowTaskPlus11.Execute(IDTSConnections100 connections, IDTSVariableDispenser100 variableDispenser, IDTSComponentEvents100 events, IDTSLogging100 log, Object transaction)
I am using the following configuration.
Flat File Source:
Enabled=True
FilterType=FileConnection
FilterFile=FlatFileConnectionManager
IsColumnDelimiterVariable=False
ColumnDelimiter=,
OLE DB Destination:
Enabled=True
MissingColumnFail=False
IsMappingVariable=True
MappingVariable=User::ColumnMappingVariable
I have checked the value in the ColumnMappingVariable and it is:
DepartmentID=DepartmentID\\r\\nName=Name\\r\\nGroupName=GroupName\\r\\nModifiedDate=ModifiedDate
Any suggestions? Thanks,
Dandy