i am not able to view the source and file and run the data reader, i have attached all the screenshots please help me with this.
Hi, did you check the column chooser settings?
Hi Yogeshwar,
Do you intend to load just Route entity members from this file?
Check the code length set up for this entity in the data model. From the screenshots you provided I see that you're loading one column as both name and description, e.g. Amsterdam-London. I recommend to use different IDs for routes, e.g. R001, R010, etc. for consistency.
You can also check data reader logs, it will tell you what's the issue with the load.
Thanks,
Anastasia
Agreed that it's not good practice to use a description as a code, a) because descriptions change and you'll then end up with duplicates for the same categories and old values which are no longer used, and b) because the wider the code the larger the index, which impacts performance.
In this case though I think Bettina's answer is the right one, it looks like Yogeshwar just needs to use the Column Chooser to re-add the File column and then he'll be able to select his input file and run the data reader by the looks of it. The alternative of course is to run it from a procedure step and select the file that way.
