export sql 2005 results in ascii

Posted on 2009-04-29
Last Modified: 2013-12-07
 I am trying to export results in ASCII format into a text file from an SQL query.  currently it is exporting them in unicode format.  i have been through the quey options and do not see an option to use ascii.  
Question by:bwanagat
    LVL 14

    Accepted Solution

    Use the SQL Server 2005 Import/Export Wizard.

    Right click on your database in SQL Server Management Studio and select Tasks then Export.

    Select your database as the datasource, and set the destination to "Flat File Destination", and change the code page to 20127 (US-ASCII).

    Click Next and then choose "Write a query to specify the data to transfer".

    Keep clicking next and then run the package to export your data to the ASCII text file.

    Author Closing Comment

    wolfman007, i apologize for the time it took to respond.  i tried your resolution many times with no success, most likely due to user error as my sql query managment skills are lacking in some areas.  I ran into several different problems to try and resolve while running it as a SSIS package.  i do believe your resolution would work under the circumstsances of a more proficient user of the system.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    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