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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-01 : 09:05:47
|
| Bunmi writes "When I use DTS to export data from a table in SQL Server 7 on NT 4 to a text file, only 255 bytes of each record is transferred and displayed when i view the text file. The table has the ff: designCol1 Char 256 However, when the table is queried with Query analyzer, it shows all the 256 bytes. I'm using DTS because I need to schedule the export.Any help would be appreciated.Thanks." |
|
|
dr fonz
Starting Member
6 Posts |
Posted - 2002-07-05 : 09:27:44
|
| I've had this problem too, there don't seem to be any settings which can fix it. The same happens if you export to a XL spreadsheet. I guess MS forgot that they extended the varchar beyond 255 when they wrote the DTS stuff?!Anyway. The only way I found to get round it was to export with a query, not a table, and convert the long varchar to a text field in the export; eg:SELECT ID, CONVERT(text, BigVarcharField) AS BigVarcharField FROM MyTableThrow the query into a SP to save effort etc. if you like.It's a bit laborious if you're just trying to whack off a quick export, but it works if you're desperate! Probably better to use BCP |
 |
|
|
|
|
|
DTS Export and Text File