I've created a SSIS project in Visual Studio and it runs well to process the text file, insert records in SQL tables and move the processed file to archive folder when I manually execute the package in Visual Studio.
But, after I deployed the project to SSISDB in the Integration Services Catalogs and created a job in SQL Server Agent, I can see that the job succeeded in the history, but the the text file was not processed, the records were not inserted to the SQL tables and the text file was not moved to archive folder.
From the Execution Information from of the package in SSISDB, the message shows:
Foreach File1 Testing:Warning: The 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.
In my Collection page of Foreach Loop Editor, I did use full folder path like \\MyTestingFileServer1\FilesInPlace\ not the mapped network drive name. The files was set as: "*.txt" and Retrive file name I select: "Fully qualified".
Please tell me what else should I check for the configuration to make the job run in the SQL Server Agent.