Post reply

exporting data to a text file

  • January 12, 2011 at 4:14 am

    #388612

    Hi

    I am trying to export data to a text file using bcp.

    here is my command

    EXEC xp_cmdshell 'bcp "SELECT * FROM sysfiles" queryout "C:\bcptest.txt" -T -c -t,'

    here is the error list i am getting

    SQLState = 08001, NativeError = 2

    Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].

    SQLState = 08001, NativeError = 2

    Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti

    ons.

    SQLState = S1T00, NativeError = 0

    Error = [Microsoft][SQL Native Client]Login timeout expired

    NULL

    anybody have any idea where i am going wrong?

    Thanks in advance

  • January 12, 2011 at 5:55 am

    #1272313

    or is there another way of doing it?

    i cant use ssis

  • January 12, 2011 at 6:03 am

    #1272316

    press Control+Left Shift+ F

    This sets your SSMS output to File.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • January 12, 2011 at 6:12 am

    #1272323

    🙂 I didnt know that

    I need to do it automatically daily

    is there a simple way?

  • January 12, 2011 at 10:56 am

    #1272500

    Have u tried the SSMS Export and Import wizard?

    and plz verify that the Browser Service is started on ur server..

    Regards,

    Farhan.

  • January 12, 2011 at 12:01 pm

    #1272546

    i can export a one off to text using the export wizard

    i cant save it as an ssis because it isnt installed

    i need to export it daily

    i dont know which browser service is on the server, how do i check?

Viewing 6 posts - 1 through 5 (of 5 total)

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