sqlserver代理运行ssis的包报错

陈荣灿 20 Reputation points
2023-10-18T07:10:53.2966667+00:00

ssis的包里面是通过odbc从mysql拉取数据,这个包在ssis上可以运行,但是部署到sqlserver后,在SSISDB下面运行这个包就报错了,同时通过代理创建job去执行这个包也不出意料的报错了。其他的通过OLEDB去sqlserver拉取数据的包都不会,就这个mysql的会。ssis的账户跟sqlserver的账户都是管理员登入,还是汇报这个错误,有朋友遇到过吗

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,853 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,386 Reputation points
    2023-10-18T08:52:12.71+00:00

    Hi @陈荣灿,

    有没有报错信息?

    能否查看一下是否是权限的问题,一般来说如果VS上面可以运行包,但是job报错的话都是权限的问题,确保你的账号有权限连接ODBC Source。

    你可以尝试使用proxy account在SSISDB跟Job里面跑SSIS包。

    参考一下这个文档

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


0 additional answers

Sort by: Most helpful