SSIS在VS中很好地处理数据，但不处理SSMS调度作业中的数据文件 [英] SSIS processes data well in VS but doesn't process data file in SSMS schedules job

问题描述

Hello Experts，

Hello Experts,

我在Visual Studio中创建了一个SSIS项目，它可以很好地处理文本文件，在SQL表中插入记录并移动处理过的文件在Visual Studio中手动执行包时归档文件夹。

I've created a SSIS project in Visual Studio and it runs well to process the text file, insert records in SQL tables and move the processed file to archive folder when I manually execute the package in Visual Studio.

但是，在我将项目部署到Integration Services目录中的SSISDB并在SQL Server代理中创建了一个作业后，我可以看到该作业在历史记录中成功，但文本文件未处理，记录未插入SQL表
且文本文件未移动到存档文件夹（当然）。 

But, after I deployed the project to SSISDB in the Integration Services Catalogs and created a job in SQL Server Agent, I can see that the job succeeded in the history, but the the text file was not processed, the records were not inserted to the SQL tables and the text file was not moved to archive folder (of course). 

为什么相同的包在Visual Studio中正常运行但在SQL Agent中的作业中没有？未正确配置或设置的内容    

Why the same package is running correctly in Visual Studio but not in jobs in SQL Agent? What is not configured or set correctly    

谢谢，

lw

推荐答案

你好，

这是因为源路径确实存在但不包含文件。

This is because the the source path does exist but does not contain the file.

因此，请查看您如何配置所有内容。此外，All Executions报告可能表明该文件未被选中。

So review how you configured all. Besides, the All Executions report probably indicated that the file was not picked.

这篇关于SSIS在VS中很好地处理数据，但不处理SSMS调度作业中的数据文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！