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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2010-07-22 : 06:34:23
|
| HI I have to import data from one table to another.All the column headings are the same so that makes it quite easy. However my import (using DTS) is failing because the "Notes" field in the source table is text datatype and the destination is image datatype.I didn't know you coud store notes as image but apparently you can.is there a way to do this? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-22 : 07:26:24
|
If you have the chance then make the destination column a varchar(max) datatype.And have a look here for the possibilities on convertinghttp://msdn.microsoft.com/de-de/library/ms187928.aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-07-22 : 07:36:15
|
| Unfortunately the destination table is part of an application so I cannot change it. |
|
|
|
|
|
|
image as notes