Importing SAS dataset via DTS Import/Export Wizard 
Author Message
 Importing SAS dataset via DTS Import/Export Wizard
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



Tue, 02 Nov 2004 03:36:51 GMT
 Importing SAS dataset via DTS Import/Export Wizard

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.



Sat, 06 Nov 2004 05:37:38 GMT
 Importing SAS dataset via DTS Import/Export Wizard
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!



Sat, 06 Nov 2004 21:59:15 GMT
 Importing SAS dataset via DTS Import/Export Wizard
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.



Sat, 06 Nov 2004 22:36:15 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

2. DTS Import Wizard won't complete the import

3. DTS import/Export wizard crashes WIN95

4. DTS Import/Export Wizard Error

5. DTS Import/export wizard error

6. Problems with DTS Import/Export Wizard

7. DTS Import/Export Wizard Error CoCreateInstance

8. DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

9. DTS Import/Export Wizard crashes!

10. DTS Import and Export Wizard

11. DTS - Import and Export Wizard

12. DTS import/export wizard


 
Powered by phpBB® Forum Software