Dataset query support

Scripts, SQL, .NET Framework
1

Dear Expert.
In my project I create Query object in Dataset ( Connect to SQLLite).
I want to use Query for inserting database into SQLlite.
I used Query in Script task.
My problem is the query was always 2 times. I don’t know why.
Please see picture.

image
image931×189 20.6 KB

image
image822×542 22 KB

Thank

2

Hi Thanos.

You need to use ExecuteCommand() instead of SelectCommand(). I had the same problem when I first tried database inserts :slight_smile: It mustn’t be documented very clearly.

Regards,
Greg Shearer