SETSOURCE

The SETSOURCE command enables you to identify one or more source databases for Integration Server to use with a load command.

Syntax

SETSOURCE "DSN=PrimaryODBCdatasource;CODEPAGE=Codepage;UID=username;
PWD=password[;][DSN=SecondaryODBCdatasource;CODEPAGE=Codepage;
UID=username;PWD=password][;]...[DSN=SecondaryODBCdatasource;
CODEPAGE=Codepage;UID=username;PWD=password]"
ParametersDescription

PrimaryODBC datasource

The primary ODBC data source name configured on the computer where Integration Server runs—case-sensitive

Codepage

The code page of the language you want to use during the current Integration Services Console session

username

The name for logging on to a primary or secondary ODBC data source—case-sensitive

password

The password for logging on to a primary or secondary ODBC data source—case-sensitive

SecondaryODBC datasource

The secondary ODBC data source name configured on the computer where Integration Server runs—case-sensitive

Example

SETSOURCE "DSN=TBC;CODEPAGE=English_UnitedStates.Latin1@Binary;UID=TBC;
PWD=Password;DSN=TBC2;CODEPAGE=English_UnitedStates.Latin1@Binary;
UID=TBC;PWD=Password;DSN=TBC3;
CODEPAGE=English_UnitedStates.Latin1@Binary;UID=TBC;PWD=Password"