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]}
Comments
Please sign in to leave a comment.