Business Intelligence SAS providers

• mala_9183

  Newbie

  Points: 7

  More actions

  September 27, 2012 at 11:29 pm

  #393273

  I have Microsoft Visual Studio 2010 installed on SQL Server 2012.

  I am using SAS dataset as source to SSIS package.But i don't have SAS OLE DB on server.

  Here my question is

  1) Do I need to install SAS environment on SQL server where BI is installed or only SAS Drivers installation will work.

  2) I have SAS environment on client machine (virtual machine),can i install

  Microsoft Visual Studio 2010 on this machine.

• Tee Time

  Hall of Fame

  Points: 3745

  More actions

  October 3, 2012 at 3:02 pm

  #1545232

  I would start with the providers first.

  http://support.sas.com/demosdownloads/setupcat.jsp;jsessionid=CA0AA101356ACBAF269E323F13B26A8B.tc5j5_external_w1?cat=SAS+Providers+for+OLE+DB