Unanswered: More of an SSIS Question, But wanted some experienced Users advice
Hey guys, this is more of an SSIS question but I need all the help I can get on this one.
I am trying to connect to SAS 9.1 via SSIS OLE DB driver, but I cannot find any real documentation on the proper use of this driver. For example what does it mean when it asks for Server or File name and then Location? I am more than lost and getting a very nasty error as follows:
Could not retrive the table information for the connection manager 'sasprod1.###.######'. A server error has occured: ; fn = ydedopn; context =sasej9lib0901.dll; fn = ydedopn; context = sasej9lib0901.dll;