im using 2008

No there is no great way to do this. The question I was wondering with the padding was more that will work well. But I was wondering when it got...

the number might go above 100 and if so i dont want 00 in front of that. is there a way around that

hi

thanks the Multicast Transform worked perfectly for what i want

ya there is a green arrow and a red arrow.

is there any way i can put a flat file destination as package run through.

what they want it to be able...

when I use that code even if I switch it around I get the following error

TITLE: Microsoft Visual Studio

------------------------------

Error at PortVal InboundLoad [Derived Column 3 [1969]]: The function "YEAR" does...

Phil Parkin (9/29/2014)

---

ronan.healy (9/29/2014)

---

i have a date coming in like this

21/03/2018

I keep getting an error. do I have to convert it I tried the following code to try and convert...

and if I used that and it found an extra column what do I do then to make it read the dat from the extra column into my package.

also even...

well at the moment when I set up the file I have set the number of columns in file.

so example the flat file I read in have 5 columns and...

sorry that did work. thought I replied ti this

ill probably have to use an sql script to update the columns as that doesn't get all 3 in for me

ok is there anyway I cant put the 3 rd expression in as anything that's not a or t I just want as comp

hi

no taking out first ? doesn't work

when I used this I get an error

BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp A": "Comp T" : "Comp"

sorry I ment the text before the date.

that's the text I want to take

so its like this now BNY Mellon - 07/01/2014

and I want it like this BNY Mellon

this is a sample from a column BNY Mellon - 07/01/2014

so all the columns will always have that date format and I want to text the text after the date