Need Help resolving Warning: Error Could not find any file that matches the filename filter setting

[Former Member]

Data Services Designer

I have a DF that outputs errors into .txt file when a error occurs during transformation from flat file to sql server table. Try to resolve above mentioned warning. Anyone have a resolution?

[former_member466847]

Based on the error message it appears the source file(s) declared in the source object can not be found.
In the Dataflow can you select the magnifying glass on the flatfile to view the data of the file, or do you get an error message?
What are the settings in the flatfile source in the section "Source Information".
Is the file used in the source flatfile object the same file used to generate the schema in the flatfile editor?

For more information in configuring the flatfile object and editor, please refer to:
SAP Designer Guide section "File formats"
SAP Reference Guide section "File format"

[Former Member]

Change Setting Skip empty Files to No does the trick

[former_member442248]

Hi. Please use the file_exist() function of DS to check in case the file is available or not.

If the file exist you can try loading the file in a staging table and check in case it is empty or not.

Regards. S

[Former Member]

The flat file (Source) file does exist. It's timestamp matches when the job was run. I believe the issue is because there is not data in the file. Is there a way to check for empty file and to see if file exists?