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).
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.
Comments
Lowell Heddings replied ago:
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.
Voters For This Link (8)
Voters Against This Link (0)