Hi,
I am planning to write from a file to a database table, which is in another linked server. I am using the following command.
Exec master..xp_cmdshell
'bcp "[LinkedServer1].DatabaseName.dbo.TableName" in "filename.txt" -S ServerName -T -c'
But I am getting following error.
A valid table name is required for in, out, or format options.
I am certain that this table exists as "SELECT * FROM [LinkedServer1].DatabaseName.dbo.TableName" is working
Can some please help me in correcting syntax issues.
Thanks
Rami Reddy