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

Dynamic Stored Procedure
Dynamic WHERE & Dates
with(updlock) - How many times on same table in single update?
Is there alternative to T-SQL USE <dbname> where <dbname> is varia
Using set theory in SQL Server 2005