The SETCATALOG command enables you to identify an OLAP Metadata Catalog database for Integration Services to use with a load command.
Syntax
SETCATALOG DSN=ODBCdatasource;CODEPAGE=Codepage;UID=username;
PWD=password[;]
| Parameters | Description |
|---|
ODBCdatasource | The 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 the ODBC data source—case-sensitive |
password | The password for logging on to the ODBC data source—case-sensitive |
Example
SETCATALOG "DSN=TBC_MD;CODEPAGE=English_UnitedStates.Latin1@Binary;
UID=Fred;PWD=Password"