Hello,
I am trying to create an ActiveX script to run in a dts package (SQL
Server 2k) that automates a section of code from vb (currently running from
access). The problem is im getting the following error message:

"Current provider does not support the necessary interface for Index
functionality"

The connection string is:

oConn.Open "Provider=sqloledb;Data Source=(local);Database=db;User
ID=sa;Password="

my research has shown that recordsets using sqloledb do not have the .seek
and .index functionality, but my question is how else can i perform the same
tasks? can i change the provider?

thanks