none
Need the Updated Data from sql server to the csv file.

    Question

  • HI all,

    We are having a asp.net 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.

    thanks

    Wednesday, April 4, 2012 12:23 PM

Answers

  • 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 http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

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