Insert a datarow into sql table

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


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

@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…

Hello ,
The screenshot is this:
imagem
Thanks

Can you use OLEDB as data provider instead of SQL Server

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

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

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

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…

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

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

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