I have a job which takes a csv file from my local drive and imports it into Snowflake. I was testing it earlier today and it ran ok earlier. I have tried to run it several times since then but now it won't work. I don't get an error message. It just gets the first row from the csv file and then doesn't process any further. I've already rebooted my pc and tried again. Same results.
As I said the file is a local file on my C drive. It reads the first row and then holds there. Doesn't process any further. I have a different job which takes data from SQL Server to the same snowflake db and that works fine.
Looking at the screenshot, one thing I am sure of is the problem is not on the input. To proceed by elimination, you could replace the tFileOutputDelimited at the reject flow by a tLogRow. Left the tDB* components
Try adding tSchemaComplianceCheck component before the DBOutput component and map the rejects to tLogRow to see if its because of inappropriate schema the data is not inserted into target.
