Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Truncating Huge Varchars

Status
Not open for further replies.
czbear

czbear

IS-IT--Management
Jul 3, 2003
11
US
I've got a table that holds paragraphs of a master document. The column graph_text varchar(8000) gets truncated to NULL when doing 100% object/data DTS.

I've tried MDAC 2.7 and it didn't help. I know it's a bad datatype design but redesignating it will be a killer. Anyone have any ideas on posible solutions?
 
Status
Not open for further replies.

Similar threads

bmacbmac
  • Locked
  • Question
SQL 'For json' query for over 100,000 records - truncating results
Replies
2
Views
599
bmacbmac
bmacbmac
MacroAlan
  • Locked
  • Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
136
Olaf Doschke
Olaf Doschke
ChrisPhillip
  • Locked
  • Question
Truncating 2
Replies
5
Views
137
Olaf Doschke
Olaf Doschke
junkmail
  • Locked
  • Question
variable not truncating
Replies
3
Views
111
gk53
gk53
WMXTeam
  • Locked
  • Question
Convert DTS package to .Net
Replies
0
Views
136
WMXTeam
WMXTeam

Part and Inventory Search

Sponsor

Back
Top