question

redtux1 avatar image
redtux1 asked

Bulk Insert and non-local file via ODBC

Is it possible to use bulk insert operations where the local file is not on the server machine? ie: Program (perl script using ODBC) running on client machine creates temp text file and via ODBC connection Bulk Inserts this into remote SQLServer table eg: $dbh->do("BULK INSERT FROM \'c:\\data\\otchk.txt\' -- local file(client) WITH ( FIRSTROW = 2, FIELDTERMINATOR=\'\t\', ROWTERMINATOR =\'\n\' ,MAXERRORS = 20 )");
odbcbulk-insert
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.