July 30, 2024 at 11:14 am
Hi,
I have installed MySql connector and configured the ADO.NET Source(.NET provider/MySql data provider).
It is all working fine.
I need to parameterize the server details like server name, database name, userid and pwd.
How can I pass variable to database name? I can't see database as the parameter in the expressions.
I need to give database name as static value in the connection manager but how can I pass as a parameter?
I have different database names from Dev to Prod.
July 30, 2024 at 11:43 am
Which client software are you using to connect?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 30, 2024 at 11:49 am
I am using SSIS (SSDT 2017)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply