source should have the path to the actual file but you are still giving the actual file itself as source.
If DMSB.txt is your file, then source file should have this. Indirectly you have to pass the absolute path of the actual file to transformation
there is a example in user guide
Btw, is it a simple text file or a excel spread sheet?
Nitin...thank you for your patience and the valuable information on setting up the Structured Parser Transformation. After reviewing the documentation I am still unable to enter an absolute file path to the source. The Selection in the Source Properties selection does not have a place for that type of entry. Below is my file's absolute path follow by the error I get when I enter it into the Object field for the file's path. The Selection window does not allow for a file path, only the file...it only contains the object. How do I get the absolute file path into the
I need your help in finding out why I received the error message below:
- [ERROR] Cannot find the input file. For a flat file source transformation, verify that you used a reference file. Verify that all referenced file paths are valid. The following file was not found: [File name: I:\TargetX\dropbox\DMSB_Banner_eport.csv]
I creating a mapping with a Structured Parser Transformation that required an absolute file path in my Source. I created a reference file called PathFile and insert my absolute path there. The absolute path was I:\TargetX\dropbox\DMSB_Banner_eport.csv
I then mapped that reference path to the structured parser input field. Afterwards I mapped my incoming fields to my Target fields. If anyone tell me what I need to fix this error it will certainly be appreciated.
I was able to find the cause of the error, my absolute file address had a miss spelled word and I had specified the wrong drive. Upon clearing those two issues up the mapping ran successfully. Unfortunately it did not update my TargetX student with a name change. Anyone have any ideas what would prevent the mapping from updating the target?