I have a question about the DSO Rowset Provider option in DTS packages. All of the information I've read suggests that with this option selected, you can extract info from the DTS package as easily as using a 'Select *' statement.

What I'd like to do is this. I have a DTS package that imports from a text file into a SQL 7.0 table. I have to fill in an additional field, so I'd like to import this text file to a recordset (via VB), and then insert it into the SQL table. Is this possible? Thanks for your help.