Post reply

BCP Invalid Object Name Error

  • December 18, 2009 at 9:08 am

    #143691

    I am trying to export results from a temporary table to a .csv file and recieve the following error -

    SQLState = S0002, NativeError = 208

    Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '#TOWNNEWS'.

    Here is my bcp command line -

    EXEC master.dbo.xp_cmdshell 'bcp #TOWNNEWS out C:\Subscribers.csv -c -S **** -U sa -P *******'

    Can someone please help me out?

  • December 18, 2009 at 10:11 am

    #1094157

    #townnews won't exist from the BCP session. It will only exist in the session that created it.

  • December 18, 2009 at 10:58 am

    #1094193

    Thank you for the help. I created a permanent table and everything executed the way it should.

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

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