Nik's Technology Blog

Travels through programming, networks, and computers

SQL DTS Designer -

Currently working on trying to automate the bulk input of web log files into a MS SQL database with DTS Designer and Active-X script.

Managed to concatenate fields and perform VB commands on the data prior to input. However running through a directory of files to input is somewhat more difficult.

Ideal DTS import solution