How to use variables in ssis? Which expert can advise me? ? ?

520shy520 · Post time: 2020-2-10 19:30:02

How to use variables in ssis?
Is it used by package configuration? There are many questions about SSIS!

sxwwdfox · Post time: 2020-7-3 13:00:02

It can be accessed through the code at the beginning of dts. in the script task. Let me give you an example tomorrow!

shadowhele · Post time: 2020-7-17 23:00:02

Dts.Variables("variable_name").Value.ToString()

520shy520 · Post time: 2020-7-25 23:30:01

Thank you for your help. I have also debugged the use of variables configured with the package. Through the package configuration, you can use the parameters in sql. It is very convenient to read the configuration of this package every time the package runs.

上帝的洗脚水 · Post time: 2020-8-25 23:15:01

There are global variable settings in SSIS. It also has scope settings. May be obtained by the following statement
Dts.Variables("variable_name").Value.ToString()

		Remember me	Forgot password?
Password			Register