hi

could you explain that to me no idea what it means or how to go about doing it

ya i no i swaped it for a full stop as there is one in it.

so file comes in like this

Net asset value per share

Net Asset Value for Ignis...

i can get this to work as all the string lenghts a re different

tried this as well still wont work

SUBSTRING(Group,1,LEN(Group) - FINDSTRING(REVERSE(Group),"-",1) - 1)

is there anything else than can...

no cant see any link in any of the posts

when i use right

RIGHT("Class",20)

just pulls back class

misread ur main you had right not rtrim

well i dont no how to pull back what i want

you mentioned use right in one of your messages so i tired it.

im new to ssis so have no clue...

if i use this

RTRIM("Class")

it pulls back class how do i get it to pull it all back without putting more than the word class in it

some of them dont have . class some pain the only thing thats def the same is the word class

how would the replace work

REPLACE("Mountain Bike", "Mountain","All Terrain")

all my data comes in differently so wont no what it is all thats the same is the class

The data comes in in an excel file the ssis package reads in this file and i want to get it to pick it up.

all the line come in as...

anyone any ideas why this isnt working right

i have a script this is it

Public Sub Main()

Dim S As String

'Building a string...

if i use variables how do i get the source description to pull back the error the way the ssis package produces it

ok got it to work

but when i open up table in database it comes in like this

EventIDEventTypePackageNameTaskNameEventCodeEventDescriptionPackageDurationContainerDurationInsertCountUpdateCountDeleteCountHost

5OnPostExecute"+@[System::PackageName]+""+@[System::TaskName]+"0"+@[System::SourceDescription]+""+ (DT_STR, 6, 1252)DATEDIFF("ss", @[System::StartTime] , GETDATE() ) + ""+ (DT_STR, 6, 1252)DATEDIFF("ss",...