Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-08-01 : 11:19:50
|
| Hi ,I would like some help in resolving bcp .I have two SQL servers with SQL 7.0 with SP 4 and there is an identical database with identical tables on both the servers . In fact one is test server and one is in production . For e.g SQL SRV 1 test Server and SQL SRV2 Production Server with identical database X with identical table say table1 . Now we are executing bcp command every day from an external NT server which fills certain data in the database X , in turn in table1 on SRV1 (test server ) sucessfully . But it fails to put the data on the production server SRV2 and it displays a message simply that BCP import failed . I observed that table on SRV1 had 4 columns and table on SRV 2 had 5 columns .The additional column on table1 on SRV 2 had ' ms_repltrans_ts column ' in it. Could it be due to this additional column that bcp fails on SRV2 and runs successfully on SRV1 ? Any ideas what else could be the issue . I am not well conversed with bcp utility in NT . The bcp command is written in perl script . What version of bcp should i run on Windows NT The database is published but it is witout this table1 .Thank you very much . |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-01 : 11:41:02
|
quote:
Could it be due to this additional column that bcp fails on SRV2 and runs successfully on SRV1 ?
Yes. Look in Books Online about how to create a format file. You can use that to specify which fields in for file get mapped to which columns in your table...Jay White{0} |
 |
|
|
|
|
|
BCP executed from Windows NT fails .