Post reply

how to make a job in sql server 2008 for export data in text file

  • December 15, 2014 at 12:25 am

    #151392

    hi,

    can any one help me . how to export data in text file using sql server 2008 job.

    please help me out,

    thanks for the help.

    immad

  • December 15, 2014 at 12:57 am

    #1764653

    You can make an Integration Services package and schedule that with a SQL Server Agent job.

    A tutorial:

    Export Data to Flat File using SSIS Package

    If you have zero experience with SSIS, you could run the SQL Server Import/Export wizard to export to the flat file. At the end of the wizard you have an option to save the resulting package. Then you can schedule that package in the job.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply