What is the best way using Perl to take a txt file with 1 million rows and import it into SQL Server 2005?
I can already do this with C# using SqlBulkCopy. I need to do this in Perl in order to run it from a linux box.
I have tried BCP and it has issues connecting to SQL Server 2005. It...
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 =>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.