¿How do I ensure that when inserting a value into a table in SQL, when it does not bring anything, it does not throw an error but instead inserts null or empty?

[mateo_marquez]

I’m trying to insert a table from a data table into Sql. But when the value is empty, it throws an error and doesn’t let me insert the value

This is the data table
[DATO1,DATO2,DATO3,DATO4,DATO5,DATO6,DATO7,DATO8,DATO9,DATO10,DATO11
DATO1,DATO2,DATO3,‘,’,DATO6,DATO7,DATO8,DATO9,',DATO11
]

[Gbenga_Odelade]

Hi,
Can you provide the error message?

[Anil_G (Anil Gorthi)]

@mateo_marquez

Looks like this is duplicate…To avoid multiple responses in different place please maintain only one thread

How to insert a datatable in SQL, without using the insert function? because I have to specify each header?

@mateo_marquez If you are using datatable directly to insert…then the column name and type should match with the name and type in DB If not you can go with run command activity with creating an insert statement…and loop through datatable Cheers

Cheers