rxm119528 just wanted to say this is now working great and doing exactly what I need it to do. I will have to go on a C# course

Thanks so...

It looks like it is timing out when trying to set the first value in the form to my dts variable dtsCampaign_Code1?

sorry error attached now:

Yes of course, labels are fine now! I tried executing the script task in SSIS and filled in 20 values, clicked on submit, then it hung for a while...

Thanks, have done that, I am getting somewhere now, there is only one line the compiler is complaining about now:

txtCampaign_Code.TextAlign = ContentAlignment.MiddleCenter;

error is:

Error1Cannot implicitly convert type 'System.Drawing.ContentAlignment' to 'System.Windows.Forms.HorizontalAlignment'. An...

I have these references at the top:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Text;

using System.Windows.Forms;

using Microsoft.SqlServer.Dts.Runtime;

do I need to use another reference for the point, font etc lines to work?

Oh great thank you, that has removed those errors. The only errors I am getting now are whenever these 3 lines appear:

...

Thanks very much for this, I have tried using and it is only giving a couple of errors, the line:

Variables vars = null;

gives error:

Error1The type or namespace name 'Variables'...

rxm119528 thank you so much! I do appreciate your help, you are a great guy thanks again 🙂

It is pulling customers out of a database according to the codes that are entered, the codes come over in a brief, there may be 1 or more than 1...

Thanks for the replies. It's running a sql stored procedure that has one argument. It's working well for the one argument, I just need to know how to...