Bulk insert problem

Hi!
I have done bcp out using -V and -q switch from one table and using only -V
switch on another table on the server running on sql server 2000. the
datatype used is native i.e. -n switch.

When I am trying to import it using BCP IN in the server having same table
structures running on sql server 7.0, process is completing successfully. But
I want to use Bulk Insert and its not importing data on sql server 2000
rather throwing error.

ref:
truncate table rplctn_cnt_lg
Bulk insert rplctn_cnt_lg from 'c:\rpl\11072CNT.txt' with
(DATAFILETYPE='NATIVE')

Error

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any
information about the error.
The statement has been terminated.

Kindly help me with this solution. We have one project in hand where the
replication uses BCP and Bulk Insert combination. No of tables affected more
than 200. No. of sites more than 1000 where sql server 7.0/msde is there. One
master database running on sql server 2000.

TIA.... Regards,
Piyush Agarwal

Hi

Assuming you are using the correct version number with the -V flags, you may
want to check out:

<a rel="nofollow" style='text-decoration: none;' href="http://tinyurl.com/6fg44" target="_blank">http://tinyurl.com/6fg44</a>

John

"Piyush" wrote:

 > Hi!
 > I have done bcp out using -V and -q switch from one table and using only -V
 > switch on another table on the server running on sql server 2000. the
 > datatype used is native i.e. -n switch.
 >
 > When I am trying to import it using BCP IN in the server having same table
 > structures running on sql server 7.0, process is completing successfully. But
 > I want to use Bulk Insert and its not importing data on sql server 2000
 > rather throwing error.
 >
 > ref:
 > truncate table rplctn_cnt_lg
 > Bulk insert rplctn_cnt_lg from 'c:\rpl\11072CNT.txt' with
 > (DATAFILETYPE='NATIVE')
 >
 > Error
 >
 > Server: Msg 7399, Level 16, State 1, Line 1
 > OLE DB provider 'STREAM' reported an error. The provider did not give any
 > information about the error.
 > The statement has been terminated.
 >
 > Kindly help me with this solution. We have one project in hand where the
 > replication uses BCP and Bulk Insert combination. No of tables affected more
 > than 200. No. of sites more than 1000 where sql server 7.0/msde is there. One
 > master database running on sql server 2000.
 >
 > TIA.... Regards,
 > Piyush Agarwal
 >