Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rharmon
Starting Member
41 Posts |
 Posted - 2002-10-18 : 12:41:52
|
| I'm almost finished with a development rotation against our data warehouse. I pulling data in from a legacy system using sprocs and openrowset. The problem I'm running into is that there are two tables with fields that are defined as sql_char(1440). When I try to bring them in using openrowset like select * from OPENROWSET('MSDASQL.1','DSN=ttlview;ServerName=10.6.5.16.1583;ServerDSN=iex;UID=;ArrayFetchOn=1;ArrayBufferSize=8;','select * from activity') ait returns Server: Msg 7347, Level 16, State 1, Line 1OLE DB provider 'MSDASQL.1' returned an unexpected data length for the fixed-length column '[a].ACTIVITY_CODES'. The expected data length is 1500, while the returned data length is 1440.But if I grab the data through DTS all is well. The data source is supposed to be ODBC 2.5 compliant except that many of the compliant data types are not available convert(activity_codes,sql_varchar) won't work.Any help would be appreciated!RObEdited by - rharmon on 10/18/2002 12:42:39 |
|
|
|
|
|
openrowset issues