CODEWITHSUNDEEP
ssisoledb
Satishakumar Awati
Satishakumar Awati

Reputation: 3790

SSIS recordset destination not working for time column

I am trying to store result set of OLE DB Source into SSIS object variable

enter image description here

In input columns tab of editor of record set destination I am getting below error for the component

enter image description here

The datatype of the column Time__c is Time in SQL server

enter image description here

Why error coming and is Time datatype not supported by recordset destination?

Upvotes: 1

Views: 841

Answers (1)

SqlKindaGuy
SqlKindaGuy

Reputation: 3591

Have a look at this:

Only test2 doesnt work cause its a DT_DBTIME2 - The others works. If that is how your data looks like:

Dervied Column enter image description here

Output enter image description here

Upvotes: 2

Related Questions