Perl Sybase::BCP

[mmatchyn]

I am trying to bulk insert the text file input.txt into a table on sql server. I am using Perl.

Here is the code:

use Sybase::BCP;
my $bcp;

eval {
$bcp = new Sybase::BCP ($user, $passwd,"$ip:$port") || die "error\n";
};

if ($@) {
print "Error $@\n";
}
$bcp->config(INPUT => 'input.txt',
OUTPUT => 'urlwarehouse.dbo.TEMP_STR_UHA',
SEPARATOR => '\t');
$bcp->run;

This is the errors I receive:

DB-Library error:
Unexpected EOF from the server
Operating-system error:
Operation now in progress
DB-Library error:
Adaptive Server connection failed
Operating-system error:
Success

 

[MikeLacey]

Hi,

Where does the error occur? In the eval section? the ->config or ->run calls?

Mike

http://www.myspace.com/micahhowzat

http://mikelacey.fuzz.com/