Getting Error from Data Flow Task + When Dynamically Loading Flat Files to Dynamic Destination

239 views
Skip to first unread message

Dandy Taylor

unread,
May 1, 2013, 1:06:33 PM5/1/13
to coz...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages