Producing a nightly tab delineated file for a SQL Server database

Tags:
SQL Server database
I wish to produce a nightly tab delineated file, based on a recordset, for our SQL Server database. How could I program this to be produced at a specific time each night?

Answer Wiki

Thanks. We'll let you know when a new response is added.

First create a DTS Package (SQL Server 2000 and older) or an SSIS Package (SQL Server 2005 and newer) which creates the file in the correct format. Then schedule the package to be executed by the SQL Server Agent as a SQL Agent Job.

In the DTS Package click on the Package drop down menu and select schedule. Set the schedule as required and click OK or Save.

In SSIS publish the package to the server, and create a new job with a single job step. Set the job step to SQL Server Integration Services Package and select the package using the available dialogs.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following