Is there a way to do a DTS load on type TEXT fields?

#1

I have a table with 3 TEXT fields. DTS doesn't seem to want to load into
TEXT fields, as I get an error from DTS when trying to do this. Is there a
way around this? For now, I use DTS to load into VARCHAR fields, then I do
an ALTER statement to change to TEXT. Is that the best way to do this? I do
stand a chance of losing some data in my DTS loads, because there are some
fields that exceed the limit of a VARCHAR field

#2

Can you give me the error message, structure of your tables, do you have
data in all the TEXT attributes, Source == ?, destination == SQL Server
? ?

--

----------------------------------------
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

"Brian Kitt" <BrianKitt (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a table with 3 TEXT fields. DTS doesn't seem to want to load into
TEXT fields, as I get an error from DTS when trying to do this. Is there a
way around this? For now, I use DTS to load into VARCHAR fields, then I do
an ALTER statement to change to TEXT. Is that the best way to do this? I do
stand a chance of losing some data in my DTS loads, because there are some
fields that exceed the limit of a VARCHAR field

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Is there a way to do a DTS load on type TEXT fields?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Is there a way to do a DTS load on type TEXT fields? - 10-01-2005 , 04:05 PM

Re: Is there a way to do a DTS load on type TEXT fields? - 10-01-2005 , 04:28 PM