Sorry if this in the wrong forum, I don't actually know anything about SAS but I have a SAS file (.sas7bdat) that I need to load into SQL Server 2008. While trying to use the "SAS Local Data Provider 9.2" I get these errors:
Error Description: A Server error has occured: ;fn=ydedopn; context =sasej9lib0902.dll; fn=ydedopn; context =sasej9lib0902.dll.
and
Error Description: A provider specific error occured (SASUPDataSet::OpenFile() : Data Set Name (cTableByteLen) too long. Not a Valid SAS Name).
The errors occurs as soon as you set the file to be a data source.
The file can be loaded into SQL Server 2000 using ODBC (SAS Universal ODBC Driver) so it is a valid file, despite what the second error seems to suggest.
Any help that can be provided would be appreciated.
... View more