Insert a datarow into sql table

Help Studio
, ,
1

Hello I am trying to send a table to SQL Server, but I ma having the following error in the insert activity:

imagem
imagem797×290 59.5 KB

The connection is ok but the insert does not work.
Can someone help me with this error?
Thanks

2

@Liliana_Novais
Can you share workflow or screenshot of the activity you have used and the query you are using for reference… Can’t help without input information…

3

Hello ,
The screenshot is this:
imagem
Thanks

4

Can you use OLEDB as data provider instead of SQL Server

5

I have the odbc coneected, so I change to the sql?

6

It looks like you are having issue with ODBC drivers on machine…
You can use connection string in below format.
Data Source=YouDBServerName;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

And in provider name property of connect activity use System.Data.OLEDB and if still does not work then use System.data.SQLClient

image

7

Thank you, now the error chanded I used ODEDB and I got:
imagem

8

Try with SQLClient option also…

  1. Can you reverify the table name(Logs or Log) in the SQL server. Also see if data table structure and DB structure is matching… It should match with number of columns present in both the tables…
  2. Try without “dbo” in tableName…
9

hello,
this is the create I used for the table in SQL:
imagem
This is the build of the table:
imagem
Tried the two option above but the error maintains

10

@Liliana_Novais
Give the same column names from DB Table to columns in Build DataTable…Without any space…

11

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