June 25, 2009 at 5:09 pm
I am trying to import data from a D3 database into sql server 2005. Some of the tables are giving me errors like:
Cannot get the current row value of column "[FACTSDEV]...[EECOV].DEPT_EFF_DATE" from OLE DB provider "MSDASQL" for linked server "FACTSDEV". Conversion failed because the data value overflowed the data type used by the provider.
DEPT_EFF_DATE is a muti-value date field.
How do I get this data into SQL Server?
thanks
June 26, 2009 at 2:17 am
Until a 'D3' expert comes along, my only suggestion would be to export the data from the source to a delimited file and bulk load that into SQL Server. My hope is that the multi-valued fields could be split into separate fields and loaded directly. If not, you could use an SSIS package to transform the raw file into something SQL Server could load.
Ok so that probably doesn't help you much, but the thread had no replies, and I felt sorry for it.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply