HTML5 Canvas
Written by: Simon Sarris
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Web Driver
  3. MVVM
  4. REST
  5. ADO.NET
  1. HTML5
  2. Ajax
  3. jQuery Selectors
  4. CSS Part 1
  5. Git
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!
Link 9857 thumbnail
User 194680 avatar

By bonlebon
via oreillynet.com
Published: Dec 27 2006 / 12:55

Faster Filtered SQL Server Imports
This article shows how to bulk load data from text files into SQL Server, using Perl's Win32::OLE module to control Microsoft's Database Transformation Services (DTS).
Vote up
Vote down
  • 8
  • 0
  • 1613
  • 0
SaveShareSend Tags: , , ,

Comments

Add your comment
User 205047 avatar

Lowell Heddings replied ago:

0 votes Vote down Vote up Reply

I've found it's often easier to bulk load data into a temporary table with no data restrictions, and then use SQL to filter the data further before moving it into the final tables.

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (8)



Voters Against This Link (0)