BCP error with SYSNAME

Hello, i have a problem when i try and bcp in data originating from a 6.5
server onto sql 2000.
The problem appears to be due to a column in the table which is defined as
type Sysname, this is different on the platforms, from being varchar(30) on
sql 6.5 to nvarchar(128) on sql 2000.
I use native for bcp out and in and i also specify -V 65 on the bcp in ie
EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
The error i get is as follows :
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP
data-file
Is there a way of getting around this ?
I suggest you use character mode BCP rather than native mode when copying
data between SQL Server versions.
Hope this helps.
Dan Guzman
SQL Server MVP
"billu" <billu@.discussions.microsoft.com> wrote in message
news:1A91A98C-740A-4840-847E-50985EA50BB1@.microsoft.com...
> Hello, i have a problem when i try and bcp in data originating from a 6.5
> server onto sql 2000.
> The problem appears to be due to a column in the table which is defined as
> type Sysname, this is different on the platforms, from being varchar(30)
> on
> sql 6.5 to nvarchar(128) on sql 2000.
> I use native for bcp out and in and i also specify -V 65 on the bcp in ie
> EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
> COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
>
> The error i get is as follows :
> Starting copy...
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in
> BCP
> data-file
> Is there a way of getting around this ?

BCP error with SYSNAME

Hello, i have a problem when i try and bcp in data originating from a 6.5
server onto sql 2000.
The problem appears to be due to a column in the table which is defined as
type Sysname, this is different on the platforms, from being varchar(30) on
sql 6.5 to nvarchar(128) on sql 2000.
I use native for bcp out and in and i also specify -V 65 on the bcp in ie
EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
The error i get is as follows :
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right trunca
tion
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountere
d in BCP
data-file
Is there a way of getting around this ?I suggest you use character mode BCP rather than native mode when copying
data between SQL Server versions.
Hope this helps.
Dan Guzman
SQL Server MVP
"billu" <billu@.discussions.microsoft.com> wrote in message
news:1A91A98C-740A-4840-847E-50985EA50BB1@.microsoft.com...
> Hello, i have a problem when i try and bcp in data originating from a 6.5
> server onto sql 2000.
> The problem appears to be due to a column in the table which is defined as
> type Sysname, this is different on the platforms, from being varchar(30)
> on
> sql 6.5 to nvarchar(128) on sql 2000.
> I use native for bcp out and in and i also specify -V 65 on the bcp in ie
> EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
> COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
>
> The error i get is as follows :
> Starting copy...
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]String data, right trun
cation
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encounte
red in
> BCP
> data-file
> Is there a way of getting around this ?

BCP error with SYSNAME

Hello, i have a problem when i try and bcp in data originating from a 6.5
server onto sql 2000.
The problem appears to be due to a column in the table which is defined as
type Sysname, this is different on the platforms, from being varchar(30) on
sql 6.5 to nvarchar(128) on sql 2000.
I use native for bcp out and in and i also specify -V 65 on the bcp in ie
EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
The error i get is as follows :
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP
data-file
Is there a way of getting around this ?I suggest you use character mode BCP rather than native mode when copying
data between SQL Server versions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"billu" <billu@.discussions.microsoft.com> wrote in message
news:1A91A98C-740A-4840-847E-50985EA50BB1@.microsoft.com...
> Hello, i have a problem when i try and bcp in data originating from a 6.5
> server onto sql 2000.
> The problem appears to be due to a column in the table which is defined as
> type Sysname, this is different on the platforms, from being varchar(30)
> on
> sql 6.5 to nvarchar(128) on sql 2000.
> I use native for bcp out and in and i also specify -V 65 on the bcp in ie
> EXEC MASTER.DBO.XP_CMDSHELL 'bcp testdb.dbo.COMMS_SP_LOOKUP in
> COMMS_SP_LOOKUP.bcp -n -V 65 -Usa -P'
>
> The error i get is as follows :
> Starting copy...
> SQLState = 22001, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in
> BCP
> data-file
> Is there a way of getting around this ?

BCP Deployment

Hi all,

I am doing a project that involved with the big volume of data to be
uploaded to the SQL server. Due to the limitation at my employer's
site, I couldn't have the bulk admin right. I am looking at the
command BCP and wonder if there is any copyright issues if I were to
use BCP and to deploy the command?

Thanx.Hi

The use of BCP and the other client tools are governed by the EULA. Without
knowing the exact details of what you are trying to do it would not be
possible to say if you are covered or not.

John

"CY Lim" <limcyang@.yahoo.com> wrote in message
news:ea2b1aa7.0310200251.3d96823a@.posting.google.c om...
> Hi all,
> I am doing a project that involved with the big volume of data to be
> uploaded to the SQL server. Due to the limitation at my employer's
> site, I couldn't have the bulk admin right. I am looking at the
> command BCP and wonder if there is any copyright issues if I were to
> use BCP and to deploy the command?
> Thanx.