Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

export sql 2005 results in ascii

 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.  
1 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.
bwanagatAuthor Commented:
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now