If you choose to run a debug session, you can specify some session parameters. The Debugger uses default session parameters for all other parameters that you cannot configure with a debug session. The Debugger Wizard displays a session page that contains the following tabs:
Select source and target connection information.
For relational sources and targets, you can select a database connection that is configured in the Workflow Manager. For relational targets, you can choose to truncate the target tables.
For file sources and targets, you can override the file name. The default locations are $SourceFileDir and $TargetFileDir. To override the default location for a source or target file, use the Session Parameters tab. Do not enter the direct path in the file name field.
Configure source and target properties.
Configure readers and writers for the source and target instances in the mapping.
When you run a debug session, the Integration Service uses default session properties for all properties that you do not configure in the Debugger Wizard.
You can select source and target connections for each source and target instance in the debug session on the Connections tab.
You can choose the source reader type and target writer type for each source and target instance in the debug session on the Reader/Writer tab.
The Properties tab displays different source and target properties depending on the type of reader or writer you select on the Reader/Writer tab. The Integration Service uses default values for all session properties you do not configure on the Properties tab.
You can configure session properties for the Debug session.