Have you tried using insert activity in database package it will bulk insert the data in datatable into tje SQL table.
I’m currently trying the “”""+str+""""
I will try this later since I’ll be needing the ID’s of those data that I just inserted and I believe that after using this activity, it returns the ID of those inserted data
This worked. The string that is generated can be used as sql query, with the proper placement of the double quotes
Thank you for all the different solutions that is provided. I really appreciate it. Well done Team
Is it okay to ask something about this even if I asked about the double quotes in the first place? or should I start another question regarding the insert activity?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.