time datatype not supported (Batch Destination)?

Nov 22, 2010 at 5:46 PM

Hi guys, has anyone got time(0) datatypes working with this component. If I include a time(0) field in the source I get:

Information: 0x4004300C at Update Target (Merge), SSIS.Pipeline: Execute phase is beginning.

Error: 0xC0047062 at Update Target (Merge), Merge [16]: System.ArgumentException: Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.Couldn't store <13:31:31> in Call Start Time Column. Expected type is DateTime. ---> System.InvalidCastException: Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.

at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)

at System.Data.DataColumn.set_Item(Int32 record, Object value)

--- End of inner exception stack trace ---

at System.Data.DataColumn.set_Item(Int32 record, Object value)

at System.Data.DataTable.NewRecordFromArray(Object[] value)

at System.Data.DataRowCollection.Add(Object[] values)

at ssisCTC.BatchDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

Error: 0xC0047022 at Update Target (Merge), SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Merge" (16) failed with error code 0x80070057 while processing input "Batch Input" (20). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

Error: 0xC02020C4 at Update Target (Merge), Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

Error: 0xC0047038 at Update Target (Merge), SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

Information: 0x40043008 at Update Target (Merge), SSIS.Pipeline: Post Execute phase is beginning.

Information: 0x0 at Update Target (Merge), Merge: 0 rows were affected by the batch SQL Command.

Information: 0x4004300B at Update Target (Merge), SSIS.Pipeline: "component "Merge" (16)" wrote 0 rows.

Information: 0x40043009 at Update Target (Merge), SSIS.Pipeline: Cleanup phase is beginning.

Task failed: Update Target (Merge)

SSIS package "Atlas - RatedCall Fact.dtsx" finished: Success.

The program '[10064] Atlas - RatedCall Fact.dtsx: DTS' has exited with code 0 (0x0).