Unable to proceed with External data Integration (Dumping data schema to transient storage failed)
I have a problem with the integration of external data. I always get the same error (no matter if I try it with CSV or ODBC)
Dumping data schema to transient storage failed
If I go to logs the following error is displayed:
Dumping data schema SymantecResponseAssessment_3ccc9ab9-21fd-48aa-bd15-710ca711edb5 to transient storage failed. Inner exception details: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
I tried different ways with the data type but everytime the same results. I also tried the same data connection on a different machine and it worked so I guess it has something to do with my SQL database. I have all the newest SU/PU/PACU installed and using SQL Server 2008.
Does someone know how to fix this problem?
Many greetings and thanks in advance