Post reply

SSIS pulling data from SAS

  • March 9, 2010 at 11:29 am

    #221411

    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

  • March 11, 2010 at 6:30 am

    #1131976

    There is some documentation on connections on the SAS site here.

    Are you getting any other error messages?

  • March 16, 2010 at 8:17 am

    #1134464

    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... 🙁

  • May 3, 2011 at 1:11 pm

    #1319351

    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