Microsoft SQL Server Integration Services Sources > Before you begin > Get Microsoft SQL Server Integration Services source information
  

Get Microsoft SQL Server Integration Services source information

Get the values of the connection properties that you need to configure from the Informatica administrator.
The following table describes the properties that you need to configure:
Property
Description
SSIS reader module mode
Connection mode to connect to Microsoft SQL Server Integration Services.
You can choose to connect using one of the following options:
  • - Files. Use the Files option to extract metadata from files and directories in the file system.
  • - SSISDB. Use the SSISDB option to extract metadata from a SQL Server connection that you configured in Administrator.
Source Directory
Required if you choose to connect using the Files option.
Specify the path to the directory that contains the files from which you want to extract metadata. For example: /home/ssis
Connection
Required if you choose to connect using the SSISDB option.
Select the SQL Server connection object that you created in Administrator.