SSIS Task - Insert Variables into Table

Transact-SQL
1

I have an SSIS SQL Task which is trying to insert variable values into this table:

Insert into MyTable (Col1, Col2, Col3)
Values (?,?), 'Nothing to process today';

The 2 related variables do exist (as number 0 and 1) and I've configured the SQL task to reference them.

But the Task fails with "syntax error or permissions violation error". Any ideas? Thanks

2

This is the case I think:

Insert into MyTable (Col1, Col2, Col3)
Values (?,?, 'Nothing to process today');

1 Like
3

Your suggestion worked @RogierPronk.Thank you.