SQL server DB connector- pass /execute a group of queries

Google Cloud Integration Services
, ,
1

when I tried to configure the sql server DB connector with with Action (execute custom query ) there is a setback which is the custom query supports one operation at a time so I had to use 2 DB connectors one for the insert statement and another one to select the number of affected rows for example.

what If I have a use case where want to execute a group of operations like a transaction, or If I want to read a group of sql statements from a file storage and then execute them on the DB.

which component/ task can I use ? or how can that be done ?

2

Hello,

One solution I see if you want to do a set of SQL instruction as a “atomic” unit is to use stored procedures if your backend supports it. In the stored procedure you can manage the transaction and do all the needed rollbacks.

Concerning the second use case, if the set of instruction you read from the storage is completely different for all iteration, I’m not sure the stored procedure will work.

Regards

1 Like