Hi folks,
I need to configure my packages' MySQL connection to operate in different environments (dev, stage and prod).
Our MySQL databases access is over SSH.
I have added the remote server's name as and expression @[User::RemoteServer] to the expression editor's 'Server' property and I need to do them same for the SSH Host. However the Advanced Properties like 'SSH Host' doesn't appear in the expression editor's property list!
Any workaround, other than putting the whole connection string as an expression into the the 'ConnectionString' property?
Cheers
MySQL Connection Manager Advanced Properties in Expression editor
-
- Posts: 5
- Joined: Sun 24 May 2020 14:17
Re: MySQL Connection Manager Advanced Properties in Expression editor
Property Expressions Editor allows setting expression for the connection properties from Devart MySql Connection Manager only (properties from Advanced tab are not available). As a workaround, please set an expression for the whole connection string via the ConnectionString property.