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

[mateo_marquez]

How to insert a datatable in SQL, without using the insert function?
because it has headers that have [ ] then it gives me an error.

Or how do I change the name of the headers to match those of the database?

headers

[PagaDesde,Beneficiario,ImporteFC,NUMERO DE CBU,IMPORTE DE LA TRANSFERENCIA,OBSERVACIONES,DOCUMENTO A CANCELAR,NRO DE DOC A CANCELAR,TipoComp,Retenciones,Estado]

SQL TABLE

CREATE TABLE ZcargamasivaITB_pagodeservicios (
    PagaDesde VARCHAR(255) null,
    Beneficiario VARCHAR(255) null,
    ImporteFC VARCHAR(255) null,
    [NUMERO DE CBU] VARCHAR(255) null,
    [IMPORTE DE LA TRANSFERENCIA] VARCHAR(255) null,
    OBSERVACIONES VARCHAR(255) null,
    [DOCUMENTO A CANCELAR] VARCHAR(255) null,
    [NRO DE DOC A CANCELAR] VARCHAR(255) null,
    TipoComp VARCHAR(255) null,
    Retenciones VARCHAR(255) null,
    Estado VARCHAR(255) null
);

[Anil_G (Anil Gorthi)]

@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