July 4, 2008 at 9:59 am
I don't seem to get an option to have a text delimiter when I choose 'results to file'. I can set the column delimiter fine.
Anyone know how to?
Cheers
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
July 7, 2008 at 8:23 am
elliot.howes
In order to customize your "Results to Text" settings Open up SQL Server Management Studio and drill down as follows.
Tools >> Options >> Query Results >> SQL Server >> Results to Text >> Output Format: Change from Column aligned (the default)
Choices are:
Column aligned (default)
Comma delimited
Tab delimited
Space delimited
Custom delimiter
If Custom delimiter is chosen, you can populate the Text Box for the Delimited of your choice.
Click "OK" and you will be all set.
July 7, 2008 at 9:04 am
Many thanks for your response but that is for the column delimiter, not the 'text delimiter'.
You can set the text delimiter when you export text and it will give you option the first time you save results to file but not again after that.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
July 7, 2008 at 9:46 am
elliot.howes
What are you trying to accomplish? Perhaps there is a different way to get you to your goal. If you are looking to dump data into a CSV file of some sort. You can also look into the SQL Server Import and Export Wizard, which will create a "quick and dirty" DTSX (SSIS) package for making a delimited file.
Right Click the database you want your data from. Tasks >> Export Data
The Source should automatically populate itself.
The Destination should be chosen as "Flat File Destination". You can change the Format of the file below.
SQL Server 2005 Books Online (September 2007)
How to: Start the SQL Server Import and Export Wizard
http://msdn.microsoft.com/en-us/library/ms140052.aspx
Hope This Helps!
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply