March 4, 2015 at 11:25 am
declare @sql nvarchar(4000)
select @sql = 'bcp [DBNAME].[dbo].[servertable] in C:\folder\serverlist.txt -SLaptop-01 -T -E -n '
exec master..xp_cmdshell @sql
Getting the below error: Please suggest.
NULL
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]Unexpected EOF encountered in BCP data-file
NULL
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
NULL
Thanks.
March 4, 2015 at 8:14 pm
SQL-DBA-01 (3/4/2015)
declare @sql nvarchar(4000)
select @sql = 'bcp [DBNAME].[dbo].[servertable] in C:\folder\serverlist.txt -SLaptop-01 -T -E -n '
exec master..xp_cmdshell @sql
Getting the below error: Please suggest.
NULL
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]Unexpected EOF encountered in BCP data-file
NULL
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
NULL
What is the format of the source file?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply