how to reslove the OLD DB Provider Error

See more:

SSIS

Hi EveryOne,

i want to save the data in excel using OPenRowset Command in sqlserver.
but i am getting the below error. kindly any one help me how to reslove this error.

Error:
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Deferred prepare could not be completed."

Query:

select *  FROM OPENROWSET(
'SQLNCLI',
'Server=User-pc;User Id=sa;password=sa123;data base=Test',
'select billing_id,process_id from Test.dbo.Billing'
) AS Employees

Thank you,