SQLTeam.com | Weblogs | Forums

SAS Export/import to SQL Server USING SSIS


#1

I have to use SAS dataset export/import to sql server ... I have checked my installed drivers are local, shared ,olap for sas under SSIS connection manager. However I tried shared with the //XXX/folder / as the network drive as my sas datasets are in LINUX server where SASAPP is installed ... My profile is also mapped to the network path...
It does not work...
Any help with examples are highly appreciated..
cannot use COZYROC as third party software is not allowed in the company...
Many thanks in advance...