January 2011 Entries

SSIS Expression to Find Text Between Characters

It will be a super short and looks like the first and last post in January 2011. So back to the topic, I decided to share an SSIS expression I crafted to extract the value concealed between two characters (I needed to get a portion of text in a file path): Substring(@[User::MyString]... - FINDSTRING(@[User::MyString... The value of MyString say could be c:\test\test(testing1234567... then the resulting text captured ......