MySQL Connection Manager Advanced Properties in Expression editor
Posted: Sun 24 May 2020 14:41
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
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