dbTalk Databases Forums  

Moving Text Column from SQL2000 to SQL6.5

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


Discuss Moving Text Column from SQL2000 to SQL6.5 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeff Swanberg
 
Posts: n/a

Default Moving Text Column from SQL2000 to SQL6.5 - 11-14-2003 , 12:46 PM






I have a critical need to backwards migrate some tables from SQLServer 2000
to SQLServer 6.5 - back onto the box/structure where they originally
resided. But, when I use DTS to push the current data back onto the 6.5
structure, I get an error when it hits the Text fields like it doesn't know
how to handle them even though the structure is the same in both DB's.

Is there a way around this? If you need the specific error, let me know and
I'll rerun the package to get it.

Jeff



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.