sql server dts: DTS Dynamic Question -- sql server dts

DTS Dynamic Question

vze1r2ht NO[at]SPAM verizon.net
10/10/2006 2:56:58 PM

sql server dts: I have a ton of IIS log files that I want to import into a table in
SQL.

IIS uses a "space" limiter to seperate into columns.

I want to import each log file into the table. I written a DTS package
to do this BUT everytime the package completes, I have to go in and
switch the source file to a different source text file.

Is there a way to dynamically do this? I'm fairly new to DTS package
management.

Alternatively, I tried using .NET 2.0 and even BCP (bulk insert) to
import the data. .NET was too slow and BCP didn't import it properly.

Re: DTS Dynamic Question

Darren Green
10/10/2006 11:10:19 PM

Try this loop method -

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]