Query Analyzer ntext data fields spilling into adjacent column when saving data

Posted on 2006-05-23
Last Modified: 2006-11-18
There appears to be no pattern as to when the "spillage" occurs, but when I return a query where fields have a datatype of ntext or text, running the query presents the data properly, however, when you click SAVE, then look at the resulting CSV files, many times the data is inexplicably pushed into the next 1 or more columns.

Has anyone seen this? How can I get clean data into a CSV file from this type of field? My output MUST be in CSV format for the "receiving" application.
Question by:pauldes
    1 Comment
    LVL 10

    Accepted Solution

    could it be that your text has commas in it?
    If it has to be csv then make sure the fields are surounded by "

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now