Michael, i think i found my problem.
I have a For Each Loop Container that is supossed to read files from a folder.
The loggin says: For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.
But that's not true. I can run the package from the BI Studios and i will run and find the files.
Here's the structure of my package:
I've got a Foreach Loop thats reading from a restricted folder (but my Windows User has access)
and its got a Variable called FileName for mapping the actual File's Name
Inside it at my Data Flow I've got a Flat File Source thats connected to a FlatFileConnManager. That Conn manager has its ConnString set to a unexisting file in C:\MyFile.txt because i have a File System Task which has a validation that requires the FlatFileConnManager to be set to an especific file and not a Variable.
But my FlatFileConnManager has an Expression for the ConnectionString to be set to the User::FileName variable mentioned before.
I think maybe somewhere there something's wrong that the log is telling me the FEF enumator is empty.
I also noticed in the SQl Server Agent that in the Steps of my Job when i go to the Data Sources tab i see my FlatFileConnManager and it's connection string is C:\MyFile.txt. Maybe that's the problem the it doesnt know it has to map it to the variable?
I have no idea.
I'd appreciate any help there.