SAS OLE DB in SQL Server SSIS

kavitakumari — Thu, 23 Aug 2018 06:24:02 GMT

Dear All,

We are trying to bring data from SAS server to SQL server using SSIS by using OLE DB data provider for visualisation purpose.

Request you to please share the PORT number that we need to open between SQL server and SAS server.

Source: SQL

Destination: SAS

PORT: Unkwown

Data flow will be unidirectional, i.e. from SAS to SQL.

TIA

Regards

Kavita

Re: SAS OLE DB in SQL Server SSIS

JBailey — Thu, 23 Aug 2018 15:24:05 GMT

The default port for Microsoft SQL Server is 1433. It is possible that your DBA has changed the port for the database.

Best wishes,

Jeff