InMemory ETL task: Declare Variable

Use the 'Declare Variable' task to declare any variables you may need in any subsequent script in your ETL project.

Examples of setting a variable:

  • SET @IntegerCounter=@IntegerCounter+1
  • SET @PathFileName=[FileListTable].[FilePath]

Examples of using a variable:

  • PRINT 'Counter = '+@IntegerCounter
  • IMPORT [tmpZendeskUsers] = [Json Zendesk].{SELECT * FROM [@@PathFileName]}
Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.