Because this does not work?

I need to insert the values ​​for each records of the Data Table (DT Excel).
They have different names so I can’t use Database insert

image
image

String.Format(“INSERT INTO ZcargamasivaITB_pagodeservicios
(PagaDesde, Beneficiario, ImporteFC, [NUMERO DE CBU], [IMPORTE DE LA TRANSFERENCIA], OBSERVACIONES, [DOCUMENTO A CANCELAR], [NRO DE DOC A CANCELAR], TipoComp, Retenciones, Estado)
VALUES (‘{0}’, ‘{1}’, ‘{2}’, ‘{3}’, ‘{4}’, ‘{5}’, ‘{6}’, ‘{7}’, ‘{8}’, ‘{9}’, ‘{10}’);”,
row(“PagaDesde”).ToString, row(“Beneficiario”).ToString, row(“ImporteFC”).ToString,
row(“NUMERO DE CBU”).ToString, row(“IMPORTE DE LA TRANSFERENCIA”).ToString, row(“OBSERVACIONES”).ToString,
row(“DOCUMENTO A CANCELAR”).ToString, row(“NRO DE DOC A CANCELAR”).ToString,
row(“TipoComp”).ToString, row(“Retenciones”).ToString, row(“Estado”).ToString)

Hi @mateo_marquez ,

String.Format(“INSERT Into ZcargamasivaITB_pagodeservicios(PagaDesde, Beneficiario, ImporteFC, [NUMERO DE CBU], [IMPORTE DE LA TRANSFERENCIA], OBSERVACIONES, [DOCUMENTO A CANCELAR], [NRO DE DOC A CANCELAR], TipoComp, Retenciones, Estado) VALUES (‘{0}’, ‘{1}’, ‘{2}’, ‘{3}’, ‘{4}’, ‘{5}’, ‘{6}’, ‘{7}’, ‘{8}’, ‘{9}’, ‘{10}’);”,row(“PagaDesde”).ToString, row(“Beneficiario”).ToString, row(“ImporteFC”).ToString,row(“NUMERO DE CBU”).ToString, row(“IMPORTE DE LA TRANSFERENCIA”).ToString, row(“OBSERVACIONES”).ToString,row(“DOCUMENTO A CANCELAR”).ToString, row(“NRO DE DOC A CANCELAR”).ToString,row(“TipoComp”).ToString, row(“Retenciones”).ToString, row(“Estado”).ToString)

Copy this and try using in the assign activity. I have resolved the error.

Hope this helps.

Thanks,
Gautham.

@mateo_marquez

I believe it is a duplicate

Cheers

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