SSIS Foreach Loop Container enumerator did not find any files while deployed on SQL server

Asked Aug 15 '17 at 11:27

Active Aug 15 '17 at 11:27

Viewed 577 times

I have created a SSIS package that imports CSV files from a folder and writes data into a database. I can run the package locally but when deployed to SQL server and trying to run it via Execute command. The Foreach Loop Container gives a warning as shown in the pic below.

I am currently using a login that is present on the Security\Logins list in SQL server as shown in the pic below:

I have given the user permission to the folder containing the files like show here below .

But I still get error while running the package. Can anyone give me clues that might lead to a solution?

asked Aug 15 '17 at 11:27

user2140740

The files are in the same folder on the SQL Server as they are on your local box? – Tab Alleman Aug 15 '17 at 12:39
Yes, they are on the same folder. – user2140740 Aug 15 '17 at 13:50
1

Can you show us the files on the Database server, and the filters on your foreach enumerator? – Tab Alleman Aug 15 '17 at 16:05

SSIS Foreach Loop Container enumerator did not find any files while deployed on SQL server

0 Answers0