2023-11-09

Ado.net connection to mysql in ssis

I have 60 table in my sql in 60 different servers from 192.168.69.1 to 192.168.69.60

When I create a single mysql connection and read data from first table its worked.

But when I create a parameterized connection with expression, it's not working and I see this error :

[ADO NET Source [2]] Error: An error occurred executing the provided SQL command: "select * from mdl_adobeconnect". SELECT command denied to user 'biteam'@'192.168.12.20' for table 'mdl_adobeconnect'

But I have full permission on all tables.



No comments:

Post a Comment