Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Can SSIS import SAS data set to SQL server DB

Author  Topic 

edwardadu
Starting Member

3 Posts

Posted - 2010-05-17 : 12:46:10
Can I use SSIS package to import a SAS dataset to a SQl table ?


edward adu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-17 : 13:00:16
try

http://www.sqldev.org/sql-server-integration-services/import-sas-91-dataset-with-ssis-2557.shtml

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

edwardadu
Starting Member

3 Posts

Posted - 2010-05-17 : 14:39:54
quote:
Originally posted by edwardadu

Can I use SSIS package to import a SAS dataset to a SQl table ?


edward adu



edward adu
Go to Top of Page

edwardadu
Starting Member

3 Posts

Posted - 2010-05-17 : 14:42:03
I am not a VB guy and I am not sure what the codes meant.

edward adu
Go to Top of Page

CozyRoc
Starting Member

2 Posts

Posted - 2011-05-03 : 15:33:17
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/
Go to Top of Page
   

- Advertisement -