Help on BCP needed

  • I am trying to BCP out 93 tables from my database. I am looping through each  table to be copied out using a cursor. Some of the tables are copied correctly and some are giving an error as follows.

    Password:

    SQLState = 08001, NativeError = 17

    Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

    SQLState = 01000, NativeError = 10061

    Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

    NULL

    my bcp string is

    bcp.exe "Test.dbo.ADUser" Out "C:\Backup\ADUser.txt" -n -SUSPRNSRANKA1\DA -q -T

    also to bcp out 93 tables it takes around 13 mins. does any body know how i can reduce the execution time and also not get the above error.

     

    thanks in advance

     

  • Do any of your table names have embedded spaces in them ? This could cause a parsing error.

     

    For performance try executing 3 batches of 31 tables concurrently ... or something to that effect.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • Thank you for your reply. my problem is resolved

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

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