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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Bulk Inserting from Perl to SQL Server 2005
DBI will not work. I need to insert 1 million rows in 1 minute. I can do this in C# with a bulk insert. But it does not work in Perl. Also it must work from a linux pc so I can't use any win32 modules. -
Bulk Inserting from Perl to SQL Server 2005
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... -
Perl Sybase::BCP
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 =>...
