In my script task i get some results. I want to pass that result to the package. How to do this. Thanks.NSG12

Create a Package Level Variable and reference it in the ReadWrite Variable section of the Script Task Dialog. Then in the script itself: Dts.Variables("MyVariable").Value = <set the value here> Note that Variable Names are Case Sensitive. Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

The easiest way is using variables. Here is an example of using SSIS variables in a Script Task: http://microsoft-ssis.blogspot.com/2010/12/how-to-use-variables-in-script-task.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Thanks all of you. It helped.NSG12