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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2007-06-27 : 16:13:57
|
| HiWe have a DTS Package which dumps the data to a text fileThe Query has NTEXT column When we execute the DTS Package, The Ntext data is truncated to 255 characters in the destination text file.But we are able to see the complete data which is more than 255 characters for NTEXT column. when we execute the same query in Query Analyzer, How can i get the complete data for NTEXT column in the destination text filePlease Help me out this.Thanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-27 : 23:23:49
|
| Should have an option in package design to set max characters. |
 |
|
|
|
|
|
NTEXT data is getting truncated in text file