Solved

SQL 2012 does not create text file from query

Posted on 2013-06-10
4
221 Views
Last Modified: 2013-06-24
Hi,

I am trying to create a '|' delimited txt file from a once off select query results but the window does not appear where I can specify the destination or the file name although the query is stated as completed successfully.  Please help
0
Comment
Question by:burny1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39236656
Can you confirm that you have 'results to file' set for your query in SQL Server Management Studio?
0
 

Accepted Solution

by:
burny1 earned 0 total points
ID: 39236816
Yes I have done that.  I have also tried different delimitation options but nothing wants to work.  This morning it refused to even show results to grid.  I suspect that I need to reload the program.

I have another computer running a 2008 module and it is currently executing the results to file query without hassles (just slow).
0
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39236891
It does sound like abnormal behaviour for management studio. Are you able to execute the query normally and confirm that a result set is being returned?
0
 

Author Closing Comment

by:burny1
ID: 39270708
reload sorted the problem
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

734 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