I need some clarification in SSIS.
1) What is the difference between Script Task and Script Component? Please tell me with good example.
2) Where to use Lookup Transformation ? Please tell me with good example.
3) What is the use Precedence Constrain Editor ?
4) How to declare Global Variable?