Hi,
I need to insert each row of datatable into SQL table, however i could add whole table at once but i need to insert each row from that particular datatable in for each row. so how can i give expression for that? Insert activity is asking for Datatable as input.
Regards,
Soorya prasad
@soorya_prasad You need to use Execute Non Query Activity, Pass the Query to Insert into the Table
Sorry i am not wrong, you want to validate the data and if that row is passed then you need to insert to SQL table.
If that is the case, you can put a condition in For each Row activity, put a if condition that if your condition satisfies, place a Execute Non query activity else place continue activity
Hope this helps
Thanks
@supermanPunch
Can you please give me the exact query as i am new to SQL queries.
@soorya_prasad It will be something like this:
INSERT INTO TableName(Column1,Column2,Column3,Column4) VALUES (“A”,“B”,“C”,“D”)
You can use variables as values also instead of A, B, C and D String values
“INSERT INTO [Table] (Column1) VALUES (Variable1,Variable2)”
We have nearly 100 columns. so I am looking for a different way and i found it.
Thanks for your opinions
@soorya_prasad Please Share the Solution you have found, So It might be useful for others in Forum who would want to do the same 
@supermanPunch Hi,
Actually i used merge data table if it already has some data, for the first run i just directly write in a data table and inserted the merged data table. so that it will write all the rows into the data table and it will be inserted into the SQL table.
Do you substitute column1 with the name of the column?