How to use Variables in different component

1. In Script Task component

Set Value:

Dts.Variables["ErrorMsg"].Value = string.Format("Connection Config Exception:{0}", ex.Message);
Dts.Variables["ErrorStatus"].Value = true;

Get Value:

string FileName = (string)Dts.Variables["FileName"].Value;

 

2. Execute SQL Task component

Set Value:

Get Value:

Thanks.

posted @ 2013-08-05 13:42  Vincent.Dr  阅读(182)  评论(0)    收藏  举报