<< Click to Display Table of Contents >> Navigation: Connectors > MS SQL Server > Connection Parameters |
Connection String |
The connection string JDBC will use to connect to the DB, of the following form: jdbc:sqlserver://<hostname>:<port>;databaseName=<db_name> e.g.: jdbc:sqlserver://172.16.10.231:1433;databaseName=dts_test_db
|
Username |
Username for the user through which DTS will connect to the DB. |
Password |
Password for the user. |
Schemas |
The names of the schemas DTS should access, separated by commas. |
Schemas are optional
If the Schemas field is left empty, DTS will access all the schemas in the database that the specified user can.