Auto-Export thru DTS, having dynamic file names

  • Hello Gurus

    I have a requirement where I want to export data from a table into a txt file or a dbf file at some intervals if data is created.

    Also, the export file name should be having date and time

    What is the best method. Pls help

    Sanjay Masawan

  • This was removed by the editor as SPAM

  • Sanyjay,

    If you know the interval between exports, you can schedule the DTS package to run at that interval.  If it depends on certain data being in  a source table, you can use query in an Execute SQL task in the DTS package to check for data, then either continue with the rest of the package or quit depending on the query results. http://www.dts.com has examples.

    See this thread for advise on file names: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=118793

    Greg

     

    Greg

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

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