Hello,
I am currently working on a script able to insert one single line of data from collected variables during the pipeline execution.
The problem is i keep running into a "Must declare the table variable "@CONNECTOR_DB"." error and i cant find how to solve it.
The script i'm trying to run is a very simple Insert :
INSERT INTO @CONNECTOR_DB
VALUES(@PIPELINE_ID,@IMPORT_DATE,@NB_ROWS_READ,@NB_ROWS_WRITTEN,@NB_ERROR_ROWS,@COMMENT,@Gaydamak _NAME)
Where @CONNECTOR_DB is @{pipeline().parameters.connectorDb}.T_ImportHistory_IH
I've tried other ways to enter the connectorDb but i keep running into syntax errors or "unexpected character ." and the likes.
Please advise.
I also want to apologize, english is not my first language.
Have a nice day.