遇到一个奇怪的问题，SSIS包在BI中运行正常但是发布到SQL Agent上运行失败。错误信息：“Command Text was not set for Command Object”。 SSIS包完成的任务是从数据库A中抽取数据复制到数据库B中，其中抽取SQL是用的变量，选择（SQL command from variable）其中的值在上一个脚本 ...

Visual Studio 2022 has been out for some eight months now, but it still lacks full support for SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), a top feature request.