SSIS 2017脚本任务未运行 [英] SSIS 2017 script task not running
问题描述
研究员开发人员,b
$
好的,所以SSIS正在踢我。我正在使用所有2017年的产品,vs,sql server,ssis等。我已经构建了一个软件包,其字面上的脚本任务设置为失败,整个软件包成功完成。我还添加了一行日志记录。包
完成没有错误,我已经尝试了b
1.运行32位/ 64位
2.更改sql目标版本到sql server 2017
$
3.查看sql日志,事件查看器,ssis报告
该软件包在2017年内运行良好,如果我将版本更改为2014并进行部署,那么它也可以在sql server 2014上运行。具体来说,脚本任务无效。
Fellow Devs,
Ok, so SSIS is kicking me in the teeth. I'm using all 2017 products, vs, sql server ,ssis etc. I have built a package that literally has a script task set to fail and the whole package completes successfully. I have also added a line for logging. The package
completes without error and I have tried
1. running 32 bit/64 bit
2. changing the sql target version to sql server 2017
3. looking at the sql logs, event viewer, ssis reports
The package runs fine inside vs 2017 and if I change the version to 2014 and deploy it then it also works on sql server 2014. It is specifically the script task that isn't working.
任何人有任何想法或想法?没有错误,没有ssms或windows中的日志。
Anyone have any thoughts or ideas? No errors, no logs in ssms or windows.
谢谢,
推荐答案
您好,
你是说脚本任务总是会成功,即使它"设置为失败"?
Do you mean the Script Task always will success even if it's "set to fail"?
然后请分享其中的示例代码和任务属性的设置。
Then please share the sample code in it and the settings on task properties.
或者您的意思是脚本任务永远都会被忽略?
Or do you mean the Script Task will always be ignored?
您可以通过在脚本中触发错误/信息消息来检查。
You can check this by firing an error/information message in the script.
请参阅 在脚本任务中提升事件
Please see Raising Events in the Script Task
这篇关于SSIS 2017脚本任务未运行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!