DTS Dynamic Question

#1

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.

#2

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

<vze1r2ht (AT) verizon (DOT) net> wrote

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Dynamic Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Dynamic Question - 10-10-2006 , 04:56 PM

Re: DTS Dynamic Question - 10-10-2006 , 05:10 PM