OData / OData/odataorg.github.io
SSIS Odata unable to cast object
Nobody has claimed this yet.
- Dominant language
- HTML
- Stars
- 73
- Forks
- 106
- PR merge metrics
- No merged PRs in 30d
Description
Situation is as follows.
- created a SSIS package
- added an Odata connection connected to Microsoft Dynamics CRM Online. Test was succesfull.
- inserted an Odata Source component in the Data Flow
- try to preview the Account collection (using collection) and then an error appearses. The message and technical details are below. What is wrong? Is it the data or perhaps a bug, I don't know.
TITLE: System.Data
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'.Couldn't store <2020-08-21> in hso_scribe_date Column. Expected type is DateTime.
ADDITIONAL INFORMATION:
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'. (System.Data)
BUTTONS:
OK
Technical details
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'.Couldn't store <2020-08-21> in hso_scribe_date Column. Expected type is DateTime. (System.Data)
Program Location:
at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at Microsoft.DataTransformationServices.DataFlowUI.ODataConnectionPage.PreviewButton_Click(Object sender, EventArgs e)
===================================
Unable to cast object of type 'Microsoft.OData.Edm.Library.Date' to type 'System.IConvertible'. (System.Data)
Program Location:
at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the SSIS OData Source preview flow at Microsoft.DataTransformationServices.DataFlowUI.ODataConnectionPage.PreviewButton_Click and trace the reported DataColumn and DateTimeStorage failures. Reproduce the Account collection preview with the Microsoft Dynamics CRM Online connection, then identify whether the Date value conversion or the expected column type is responsible; done means a confirmed cause and documented fix or workaround.
Written by the indexing model from the issue text.
Assessment
- Domain
- api, data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100