SSIS deployment variable issue

I created an SSIS package that uses a loop for each container and an Excel connection string that I created from a variable so that I can loop through multiple files. My package works without issue, and if I have multiple files in the source folder and I just execute the package, it works fine, looping through all the files, doing what I want it to do.

The problem is when I deploy the package. If I have files in my original folder it runs without error, but when you look at the original folder it still has files. Digging a little deeper into the package, it says it looks like it says no files were found. If I manually executed the dtsx file in loops with no problem and imported everything as I should.

Is there any reason that after deploying the package, it cannot recognize the files or the variable in which I store the filename?

+3


source to share


1 answer


It looks like it might be permission related. Does the SQL Server service account have permissions on the directory where the files are stored?



0


source







All Articles