Thanks Andy,

That works for that part and has shown me how to build on it.

thanks again

Can someone have a look at this as i keep getting an error

=iif((First(Fields!IsSales.Value, "spBOSS2012_Reports_InvoiceHeader") = 1 or (Fields!NEWBOSS.Value, "spBOSS2012_Reports_InvoiceHeader") = 0 ), True ,False)

If im right in my...

Thank you, I have just read that thread and should be able to sort this issue out from that example

Hi,

I understood the example Any gave, but what i dont follow and needed an example of is where he says

'If you want to do this for values based on more...

Hi, thanks for the reply, I did try your suggestion but failed. Is it possible for you to give me an example, im not asking for the complete solution, just...

Thanks Guys, I managed to sort it 🙂

brilliant, thank you 😀

i have tried adding that code but am comming up with the following error;

A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll

Public member 'GlobalVariables' on type 'IDTSPackage90' not found.

...

The destination machine is windows 2003 server with SQL Native Client Installed, so im guessing theres some bits n peices im missing from there. As for the Application, im...

Hi Daryl,

I may not have explained my problem  enough ...

Clients send in files during the day  which need to be checked and imported into the sql server. When the files...

Dan  thanks for the help, unfortunatly i havent managed to resolve the issue, instead im having to build the statement in a scrip task then parm it into the execute...

Problem is sorted, i was using the wrong data connection..... well it is early here  lol

Thank you Lisa I have now managed to resolve it  

i sussed it eventually, 

This is what i have done, and for the life of me i carnt get it to work,  If i substitie a value for the @glicence its fine  works...