通过SSIS读取Mysql数据,在VS开发环境当中没有问题
在发布并创建Job以后运行报错,获得以下提示信息:
Message
Executed as user: XXXXXX\XXXXXX. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5613.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 9:49:26 AM Error: 2019-05-06 09:49:26.75 Code: 0xC0208449 Source: Data Prepare ADO NET Source [2] Description: ADO NET Source has failed to acquire the connection {DF266534-1D04-499C-B37B-F4F3A39E7DF5} with the following error message: "Authentication to host 'XXXXXXXXXXX' for user 'XXXXXXXXX' using method 'mysql_native_password' failed with message: Access denied for user 'XXXXXXXXXX' (using password: YES)". End Error Error: 2019-05-06 09:49:26.75 Code: 0xC0047017 Source: Data Prepare SSIS.Pipeline Description: ADO NET Source failed validation and returned error code 0xC0208449. End Error Err