Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi I am trying to run a bcp comm

Status
Not open for further replies.

chiarak

Programmer
Nov 26, 2001
23
0
0
AU
Hi

I am trying to run a bcp command to import data into a sybase database from a perl script. I have a text file which I create as tab delimited and I use the following command to perform the import bsb in perl :
print `bcp dbname..table in filename -c -eERR -Sserver -Uuser -Ppwd`;

The bcp fails after 11197 rows (there are 12464 in the file) each time which the error :
Unexpected EOF encountered in BCP data-file.

When I execute the same command on the same file fom command line in UNIX the bcp runs error-free and imports into the table.

Any ideas on why it is causing problems when trying to run it through perl???


THANKS!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top