SSIS 包在作为作业运行时不插入记录 [英] SSIS package not inserting records when run as Job

问题描述

我想将我的 SSIS 包作为作业运行.我已成功创建作业和包.它运行时没有任何错误，但它没有将记录插入到数据库中.

Hi I want to run my SSIS package as job. I have successfully created job and package. It runs without any error but it is not inserting records to the database.

但是当我使用 DTEXECUI.EXE 运行相同的包时，它会在数据库中插入记录.请帮忙.

But when I run the same package using DTEXECUI.EXE It is inserting records in the database. Please help.

推荐答案

正如所讨论的，发现包使用 Environment Variables 作为连接管理器 SQL Server/Agent/SSIS 的一部分需要重新启动服务才能获取这些新变量.

As discussed, it was discovered that the package was using Environment Variables as part of the connection manager, SQL Server/Agent/SSIS service needed to be restarted for these new variables to be picked up.

这篇关于SSIS 包在作为作业运行时不插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！