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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Outputting query to file not working right

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-20 : 08:28:51
Deeba writes "I'm a Newbie at this, but my script (which generates xml output) is running fine. The problem is when it is opened the file has been broken up into lines, when it should be one long file(unbroken). The file format is either .rpt or .txt. They force a new line at character 2034 and it usually breaks up an XML tag Any ideas? This is really frusterating me!

Thanks"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-05-20 : 10:44:49
Sounds like it is all on one line and the whatever program you are opening the file with is breaking it. There is a maximum line length for every program that I know of like notepad and MS Word. What are you opening it in? If it's XML, why does it have to be all on one line?



Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -