Hello ! Whats the best possible way to extract data out of SAS datasets using SSIS?

check http://www.ssas-info.com/ he is one of the best in SAS and SIS http://www.ssas-info.com/analysis-services-scripts/1622-script-to-automate-ssas-partition-management-sql-ssis Sincerely SH -- Please kindly don’t forget to mark the post(s) that answered your question and/or vote for the post(s)

I don't think he's referring to SSAS - he's referring to SAS. IMO, you should do a search here for "SAS extract" to see what you get. I'm sure someone else has discussed this recently. If that doesn't help - what kind of drivers do you have to get into SAS data? ADO? OLE DB? ODBC?

Todd, Thanks, but I didnt find anything after using the search facility. I dont have any drivers right now, but can get the appropriate ones as recommended. I have SSIS and SAS datasets which need to be read and written into a SQL Server database. Any suggestions?

I'd recommend an OLE DB driver first, but if you can get your hands on any of those, you should be just fine. You probably want to use the Data Flow Task to set up an OLE DB Source to extract your data, then send it to an OLE DB Destination that connects to your SQL database. If you're not familiar with SSIS and how to use it, I recommend you look in the FAQ for free training resources.

Todd,Thanks, but I didnt find anything after using the search facility.I dont have any drivers right now, but can get the appropriate ones as recommended. I have SSIS and SAS datasets which need to be read and written into a SQL Server database. Any suggestions?I think the search is broken. Check these posts:http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/f65957ec-ce45-4fbc-be48-fd4a0f39facahttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/791e43db-7b57-42c4-a891-697dd5ed91c7SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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/