Tried that, got this error. Also, do you think the file permissions for the csv file has to be 777? Like the folder permission where it needs to have read, write, delete access. I dont think it applies to the csv files since they keep changing, but still wanted to check with you.

So I did like you said, and I am not sure why it keeps saying there was no file and ends the workflow. in the file collector I am giving the exact filename.csv for it to look for, even then it is not finding the file. Not sure what am I doing wrong. I even have the storage dir set the exact same for both. Also is there is a simple code that I can use or a syntax that you can share if I wanted to use the execcommand?

Hi Jon,It is soo great to see your response. I am no longer with Accenture, so I get stuck sometimes trying to figure out on my own when I cant find help within my new firm. Thank you so much for taking time to respond.I am not sure how to use or configure the execcommand(), so I tried using the File transfer activity and I gave my archive location under the 'file historization settings' and reran the workflow, but it still didnt transfer the file to the archive folder. Screenshot attachedI trie...

Thanks Dave, i was able to figure it out and change the data formats and it worked. Appreciate the help!

Thanks Sourabh, thats what I thought. Appreciate the help!

Hi Dave,Thank you so much for reaching out. I wasn't expecting any help anytime soon. Below are my 4 columns names and their data formats in the Data schema where I created the table. As you can see I have 4 columns with 4 different data types that were created as per the business needs. column name Data formatcol1longcol2string 50col3booleancol4uuidList of options that the Data loading activity gives to pick and match the data format for each column based on the data schema being updated. If yo...