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