[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Query Auto Export

Posted on 2009-04-22
1
Medium Priority
?
234 Views
Last Modified: 2012-05-06
Hey all,

I have a query that I need to run daily, and automatically expert the results to a comma delimited, tab delimited or a txt file. Is this possible? Trying to automate a manual process right now.
0
Comment
Question by:ValleyENT
1 Comment
 
LVL 8

Accepted Solution

by:
tpi007 earned 2000 total points
ID: 24208023
I would create SSIS package and run via SQL Server Agent as scheduled task.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

834 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