InMemory ETL task: Insert Into

The 'Insert Into' task can be used to insert values in existing tables.

The insert method for the value can be one of three types:

  • Variable. With the 'Variable' option, you can insert values from any predefined variables.
  • Fixed value. With the 'Fixed value' option, you can type in a fixed value to be inserted.
  • Expression. With the 'Expression' option, you can use expressions/functions to insert a value.

Example: Inserting three different value types in a table

DECLARE @Count as int
SET @Count=1
CREATE TABLE [NewTable] (CountField int, DateField datetime, FixedValueField int)
INSERT INTO [NewTable] (CountField, DateField, FixedValueField) VALUES (@Count,GETDATE(),10)
Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.