I am trying to import a SAS dataset using the
Import/Export Wizard. I am getting an error:
"Context:Error calling GetRowset to get DBSCHEMA_TABLES
schema info.Your provider does not supportall the scema
rowsets required by DTS."

Any info on the cause of this error???

Thank you.

Fernando

The provider  does not support the functionality required by DTS. What
provider are you using for the SAS dataset?  Have you tried creating a DSN
and in DTS use Other (ODBC Data Source) as the provider?

This posting is provided 'AS IS' with no warranties, and confers no rights.

Hi David,
Thanks for the reply.
I used both the SAS IOM data provider and SAS Local Data provider, and
both did not work.
I already tried creating a DSN, and I was able to import a SAS dataset
into SQL database, only if I login as an Admin (Windows 2000
Professional operating system).

Thank you.

Fernando

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Fernando,
  During the import the account used to connect to SQL Server will need at
least permission to insert into the destination table.  Depending on what
the package does, ex drop and recreate table,  additional permission maybe
required.  So to execute a package you do not need to necessarily by an
administrator.  So check if the SAS dataset has any permission requirements
that would require administrator rights.

This posting is provided 'AS IS' with no warranties, and confers no rights.