>>>Can anyone think of a reason that
>>>
>>>exec master..xp_cmdshell 'bcp "select * from tempdb.dbo.webdata_donation_report" queryout "C:\temp-data\data_file.xls" -c -t\t -T'
>>>
>>>works ok on one instance of sql server but not on another.
>>>
>>> the table tempdb.dbo.webdata_donation_report exists on both servers but one server gives an error
>>>
>>>SQLState = 42S02, NativeError = 208
>>>Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'tempdb.dbo.webdata_donation_report'.
>>>SQLState = 42000, NativeError = 8180
>>>Error = [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
>>>NULL
>>>
>>>the other server finds the data
>>>
>>>NULL
>>>Starting copy...
>>>NULL
>>>3 rows copied.
>>>Network packet size (bytes): 4096
>>>Clock Time (ms.) Total : 1 Average : (3000.00 rows per sec.)
>>>NULL
>>>
>>>Thanks
>>
>>Do you spell the name of the table exactly including casing? Just ruling out possibility of case sensitive collation of tempdb
>
>Hi Naomi
>
>no the case is the same I did check that.
>
>On further investigation on one server none of the tables in tempdb can be accessed by the select. On the other server any tables in tempdb can.

You need to check permissions on the account execution the package to the Tempdb.