Hi,
I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.
And also if it is possible how to do it
Thanks.
Hi,
I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.
And also if it is possible how to do it
Thanks.
Hi.
My answer is yes and no.
No because you can’t do this if you use the default sql connector. They accept only 1 query and return 1 resulset.
Yes because you can create your own connector that will execute 2 or more query and return 2 or more resultset.
If you have two distincts queries, I recommand to create two task that will both execute one query. It is more readable.