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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-09 : 07:15:55
|
| xavier writes "I import in SQL2000 data from PROGRESS with OpenLink ODBC driver.If I have a variable field lenght 8, it's possible with PROGRESS to write more 8 characters, example 10.ODBC driver is able to read the 10 characters (I can see that with a utility program from OpenLink)But SQL Server sees only 8 characters.In the DTS, I "disconnect edit", and in "task", "copy data ...","transformation", "DTS transformation_..", "source column", I change the lenght 8 --> 10.In the object table I indicate 10.But no resultat !Have you a idea ???Thank you in advance ..." |
|
|
|
|
|
importation data : truncate field