SSIS Equivalent?

Question

Post reply

SSIS Equivalent?

imani_technology

SSCrazy Eights

Points: 8200
More actions
June 14, 2010 at 3:17 pm

#222662

If I wanted to derive the file name from a path in T-SQL, I would use the following:
LTRIM(RTRIM(REVERSE(SUBSTRING(REVERSE(b.filename),0,CHARINDEX('\', REVERSE(b.filename), 0)))))
However, I don't think there is a CHARINDEX function in SSIS. So what would be the SSIS equivalent to get the job done?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Refer to find a list of various SSIS functions

http://technet.microsoft.com/en-us/library/ms141671.aspx

in particular - FINDSTRING

http://technet.microsoft.com/en-us/library/ms141748.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 2

Thanks to you, I think I'm gaining an understanding of Findstring, except for one thing: how do figure out the LAST occurrence of the "\" character within the string?

Phil Parkin SSC Guru Points: 246941 More actions · Answer 3

Reverse the string, find the first occurrence in the reversed string and then subtract that from the total string length ...

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Phil Parkin
Reverse the string, find the first occurrence in the reversed string and then subtract that from the total string length

And here is a link that explains the REVERSE function

http://technet.microsoft.com/en-us/library/ms141049.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]