SAS OLE DB in SQL Server SSIS

[kavitakumari]

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

[JBailey · Accepted solution]

Hi @kavitakumari

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