个别ssis包运行并加载数据，但在部署时无法加载 [英] individual ssis package runs and loads data, but fails to load when deployed

问题描述

我有 一个SSIS包，它读取一系列.csv文件并加载到一个sql server表...

I have  an SSIS package that reads a series of .csv files and loads into a sql server table...

它可以单独工作，但当我部署它时，当我尝试从它运行它ssisdb\ path， 我收到一个警告，说找不到文件，作业完成但没有加载。

it works fine individually, but when i deploy it and when i try to run it from ssisdb\ path,  i get a warning that files cannot be found and job completes fine but nothing is loaded.

现在在我的个人ssis包中，我指定了什么要在参数中选取的文件，然后是"文件"。对于每个循环容器的部分自动填充我输入的任何参数.csv ...当我部署
时它为什么不起作用 

Now in my individual ssis package, I specify what files to pick up in the parameter, and then the "Files" section of For each loop container gets automatically populated with whatever parameter I enter .csv...why is it not working when I deploy it 

推荐答案

基本上，当我在ssisdb中部署它时，ForEachLoop集合中的Filespec表达式具有ssis包用来读取文件的值

Basically, the Filespec expression in the collection of ForEachLoop has the value that the ssis package works with to read the files

我在那里定义相同的东西？

now when I deploy it in ssisdb, should i define the same there ?

这篇关于个别ssis包运行并加载数据，但在部署时无法加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！