Home Forums SQL Server 2005 Development Output a sql resultset to csv automatically with sql job RE: Output a sql resultset to csv automatically with sql job

  • October 3, 2008 at 1:09 am

    #880309

    Hi

    Is there a specific reason why you want to use a batch file to export the results produced to a csv? Why don't you use SSIS to generate the results for a csv?

    If you use SSIS to do this you create a package to export the information and then you schedule the package in a job to run when ever you want it to.