OK here is some test data and what I want to do

-- DROP TEMP TABLE IF ALREADY EXISTS

If OBJECT_ID(N'tempdb..#OutputTable', N'U') IS NOT NULL DROP TABLE #OutputTable

CREATE TABLE [#OutputTable](

[FirstName] [varchar](255) NULL,

[LastName]...

Thank you SSCrazy

The other problem I have is that if I pass in NULL Values for @pFirstRow  and @pLastRow , then the whole expression gets evaluated to empty!

Hi Anthony

I just realized that on running a trace. I thought the guid was being used elsewhere but it is being generated and used further down.

Sorry I hadn't spotted this...

Hi anthony

Attached is a screen grab of the whole flow and a screen shot of the task that creates the table

There was a trigger which was unconnected with this part of the database.

I disabled that trigger and re-ran my code

I still get table created with the GUID

Hi Phil

that worked perfectly!

so I amended my statement as follows

set @Statement = 'sqlcmd -v varClientURN=5766 varOfferingURNList = "200,210" varFromDate ="01-Jan-2018" varToDate = "02-Jan-2018"

Thanks for your help

Thank you....so is it quite straight forward to create a script task that can modify the DTSconfig file?

thanks Des

Thanks Des

If i wanted to extract the left part of this (8063)   and pad to 4 characters then how i would change the above please?

Brilliant Phil.

That works for me.

Thank you very much

Hi Jeffrey

I tried the first of those statements you suggested:

=Lookup(IIf(Fields!RunStatus.Value.Contains("(Failed)") , "Failed", Fields!RunStatus.Value), Fields!Status.Value, Fields!Colour.Value, "StatusColour")

And that worked perfectly!! Thank you so much for your help 🙂

this is the underyling data

I tried the expression you suggested in the Lookup expression for Color and statuses which featured 'Failed' are not being shown as red.

Please see the attached screenshot of the report...

tHAT

Hi Jeffrey

Im afraid that didnt work for me