When inserting to sql ,this error is showing

Help Studio
, ,
1

Capture
Capture1414×839 59.1 KB

2

In your Query activity, can you share the property window - do yo have a connection passed in and also enter in DB details separately?

1 Like
3

its passed separately, and safe

4

Hi @TimK
I Hope you have given both Connection string and existing connection in insert activity properties. Try to give at least one connection instead of both.

Regards,
Shilpa.

1 Like
5

Tried, Again And Again

6

But Not able to figgure out the error

7

Can you please share the properties of insert activity, just take a screen shot and post it here so that it will be easy to understand.

8

You only need one connection property for the SQL.
One of the below combinations should be used, not multiple etc.

  • Connection String + Provider Name
  • Secure connection string + Provider Name
  • Existing connection

image

1 Like
9

Hello @opkushwaha999

I hope you have used a Connect activity to create a db session. If yes you will be getting a db session variable which can pass it to the Insert activity. In the properties, you can provide the variable to the existing connection field.

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.