SSIS pulling data from SAS
-
I am trying to access SAS via the SQL Server SSIS OLE DB and I am having a lot of issues. I cannot find any documentation on how the connection managers need to be set up, and every time i try to get a list of tables I get the following error:
A server error has occurred: ; fn=ydedopn; context =sasej9lib0901.dll; fn = ydedopn; context = sasej9lib0901.dll; fn = ydedopn; context =sasej9lib0901.dll
Has anyone tried to do this, or does anyone know anything about this error?
Thanks for your time
Jim
-
There is some documentation on connections on the SAS site here.
Are you getting any other error messages?
-
No that is the only error msg that I am getting. I have been all through that documentation...and nothing in there jumps out at me regarding whats going on...I really need to find someone who has done this already... 🙁
-
CozyRoc have just released new adapters for reading/writing SAS's sas7bdat files. These are the relevant components:
CozyRoc SAS Data Source - for reading sas7bdat files.
CozyRoc SAS Data Destination - for reading sas7bdat files.
The new adapters doesn't require installation or licensing of SAS® Analytics because they are implemented with independent engine.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply