• Hi Paul,

    Andy has given the solution for the "one result" problem.

    As for the pop-up message I use it for debugging (sometimes it helps me understand). I use a script task in Control Flow view.

    1. drag a script task object from the tool box

    2. pass the variables that you want to see the result (read or write it does not matter)

    3. edit the script and the code in C# is as follows, just adapt for what you need. I included a string concatenation with the variable (VariableName) value because it can come in handy:

    ...

    public void Main()

    {

    MessageBox.Show("YOUR MESSAGE: " + Dts.Variables["VariableName"].Value);

    Dts.TaskResult = (int)ScriptResults.Success;

    }

    ...

    hope it helps and feel free to ask 🙂

    I have registered very few SSIS contents in my blog (http://ismamad.blogspot.com/[/url]) if want to take a look it might have something to help you out.

    Complements,

    Bruno