I have looked at a few posts, and also the following MSDN Site
Ideally I would like to Open a Recordset using a DTS ActiveX Script (VB essentially) and once I have the recordset open, i want to then DTS it into a Table in my SQL Server.
INSERT INTO MyTable
This is instead of the Inserting each record individually which I have found in a few places on the web and EE. I think you must be able to just Insert Into somehow??
I look forward to your thoughts.
Thanks in Advance!