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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exported File Very large

Status
Not open for further replies.
olibh

olibh

Programmer
Mar 21, 2002
13
0
0
IE
Hi,

I am using SQL server 2000 and am storing an xml string in a sql field of datatype text, length 16.
The size of the xml string may vary from small to quite large but whenever I export the file to disk (using a scheduled DTS task) the file created is always the same size - over 2mb.
This is causing me problems - is there any way to reduce the size of the file ?
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
marn1997
  • Locked
  • Question
Large data base to back word engineer
Replies
5
Views
66
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
142
Auguy
Auguy
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
45
bmacbmac
bmacbmac
ahmedsa2018
  • Locked
  • Question
How to export 20 milion rows to only one file ?
Replies
2
Views
71
JeffModen
JeffModen

Part and Inventory Search

Sponsor

Back
Top