No error but nothing was written in AZURE SQL table using sde connection file

Any warnings? It can be that there's some attributes which are not the right type for the schema in SDE. E.g maybe a sting going into an int column

Hello @arthy​, joining the conversation a little late, apologies! If it indeed is a schema mismatch issue, you could use '+ > Import from dataset' to grab schema of an existing table. However, I notice you used an attribute value to define the table/featureclass name, so I am unsure Import will work in this case! Hope this helps, Kailin!