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 |
|
kairoll2003
Starting Member
2 Posts |
 Posted - 2009-04-24 : 04:19:43
|
| Hi,I'm importing the table from informix database to sql server 2005. But there are some columns in the table getting truncated. As an example, in informix the account_no column has the data of A-123-ABC123. But after I import the table, the data becomes A-123. The rest of the string is missing. When I check the table properties, it stills show the char properties exactly like source.Anyone know why this thing happen? FYI, i'm new in sql server 2005. Before this I use DTS in SQL Server 2000 to transfer data.-Khairul- |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-04-24 : 04:21:49
|
| Check your column datatype and size.In varchar field if the size is low, the data get truncated as u got!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
kairoll2003
Starting Member
2 Posts |
Posted - 2009-04-24 : 05:01:36
|
| Hi,I've checked it. The column datatype and size is ok. I mean its same with the table that I export from.-Khairul- |
|
|
|
|
|
|
the data are truncate after import