Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:30:13
|
| Fernando writes "I am trying to import a SAS dataset to SQL Server database using the Import/Export Data Wizard. I used SAS IOM Data Provider for the data source. I am getting the following error after filling up the desiniation and clicking the <Next> button:"Context:Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema rowsets required by DTS."Any help you can provide would be greatly appreciated. Thanks." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-05-20 : 12:03:43
|
| DTS is trying to go get information about your source data do that you can specify transformations to the source. The provider you are using is not allowing DTS to get all of the information it needs. Are you sure the provider you are using is fully OLEDB compliant? If not, just about the only thing you can do is find another provider.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Importing SAS dataset to SQL server 2000 database