CODEWITHSUNDEEP
sql-serverssisssis-2012
pete
pete

Reputation: 101

SSIS xlsx For Each File enumerator is empty to SQL Server

I have a number of .xlsx files in a folder I wish the package to loop through and load. It loads the first one fine (the original you link), but I keep getting the error.

For each file, the enumerator is empty

I have even tried in the Foreach loop editor - collection set the Files of Wild. Wild to see if work, and the same error occur.

All Excel files have the same sheet name Data columns etc. I am loading the data into SQL Server. The variable path is correct.

Please help.

Upvotes: 0

Views: 712

Answers (1)

pete
pete

Reputation: 101

Solved. The issue was folder permission. I did a test to local machine instead and it worked.

Used c:\ instead of p:\

Upvotes: 1

Related Questions