We have a some ETL processes that read CSV files that are output from SAS programs. I'm in the process of upgrading one of these ETLs and was wondering if I could use SSIS to read directly from the SAS dataset.
Has anybody done this successfully?
+1
A:
See here
"You can use SAS Local Data Provider (can be downloaded separately and comes as part of SAS for Windows installation). "
Sam
2009-09-16 00:26:31
I have had sporadic success with this method. As in sometimes it works but mostly I get errors. There seems to be nothing else available. If I can find the root of my errors I'll add it here.
CTKeane
2010-01-22 13:54:33
A:
Hi Sam,
What environment you are using? I'm using SAS 9.1.3. And I tried SAS Local Data Provider 9.0 SAS Local Data Provider 9.1 SAS Local Data Provider 9.2
But none of them can work with SSIS. Always gives me error "The Local Provider does not currently support SQL processing.
I haven't actually used it, just found some reference material for the OP's question.
Sam
2010-01-25 15:14:57