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 fo...

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 Fil...

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...