Post reply

Export data automation

  • June 18, 2009 at 9:47 am

    #131267

    I need to schedule a job for every week to run export data from table in SQL server to flat file on specific drive, how can I do it?

  • June 18, 2009 at 11:17 am

    #1011947

    You can create an SSIS package to export the data out of the database and then schedule that SSIS package within a job. Hope this helps!

    Thanks!

  • June 18, 2009 at 12:41 pm

    #1011988

    I know how to create with wizard, but it does it and export it, but how can I save it and call it from the job?

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

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