SmartConnect schema file needs to be recreated
If the file name changes each time but the format is the same, then I would change the Data Source to a Folder Data source. This allows you to set up a file template and schema.ini based on that template and the file name used for the data source will not matter.
I’m having a similar issue where I am copying an existing map (ODBC Text) and pointing to a new file. As soon as I do this I cannot connect to the file. We are using a script to create the data from the csv file and it looks like if I use the folder data source I cannot use the script. Thoughts? And yes, this is Matt who worked with you at a former employer. Thanks, Lorren! Would be happy to do a screen share with you.
If you would like to submit an answer or comment, please sign in to the eOne portal.