I have a csv file that needs to be inserted to a MSSQL table, however the table has an auto increment ID field that is set to auto generate a number, how to ignore it during the insertion phase, as I'm getting an error even though I'm leaving it as blank field. Should I remove the column from the DBoutput?
This is relatively straight forward, but hidden. You need to go to the Advanced settings of your database component and select "Use field options". You will then see all of your columns. Just untick the insert and update ticks next to your autoincrement column. Then you are done 🙂
This is relatively straight forward, but hidden. You need to go to the Advanced settings of your database component and select "Use field options". You will then see all of your columns. Just untick the insert and update ticks next to your autoincrement column. Then you are done 🙂
