Need the Updated Data from sql server to the csv file. RRS feed

  • Question

  • HI all,

    We are having a application which has back end as sql server 2005. Now we need

    a functionality which provides a csv file that contains the data  which is updated in the

    table(only the columns which are updated need to be exported in csv file).

    Would like to have some suggestions. I am not an expert in sql server, Your help will be appreciated.

    Please note we don't have integration services installed and can't install it right now. so i guess

    probably we will have to do it with triggers only.


    Wednesday, April 4, 2012 12:23 PM


  • Your options are

    1) Linked Server

    2) SSIS package

    3) EXEC  master..xp_cmdshell 'SQLCMD -S Server\SQLSERVERDEV2005 -E -Q "SELECT TOP 10 * FROM pubs.dbo.authors" -b -o c:\myoutput.txt', no_output

    Best Regards, Uri Dimant SQL Server MVP

    • Marked as answer by KJian_ Tuesday, April 10, 2012 7:49 AM
    Wednesday, April 4, 2012 12:30 PM