How to view the value of SSIS variable updated from SQL?
In order to view the value passed to SSIS Variable from SQL Task add an script task after the SQL Task and include the code given below:
Consider the variable name is "User::IncrementalDate":
Public Sub Main()
MsgBox(Dts.Variables("User::IncrementalDate").Value)
Dts.TaskResult = ScriptResults.Success
End Sub
Note: Check User::IncrementalDate variable as ReadOnly variable i n Script task.
In order to view the value passed to SSIS Variable from SQL Task add an script task after the SQL Task and include the code given below:
Consider the variable name is "User::IncrementalDate":
Public Sub Main()
MsgBox(Dts.Variables("User::IncrementalDate").Value)
Dts.TaskResult = ScriptResults.Success
End Sub
Note: Check User::IncrementalDate variable as ReadOnly variable i n Script task.
No comments:
Post a Comment