How can I write a conditional split expression that separates row by string in SSIS? -
i trying filter data in ssis specific string. row has"csc" following name in column holder_name needs discarded. created conditional split , inputted expression findstring("csc", holder_name, 1) > 0
. yet nothing outputs specified second destination.
you have arguments backwards. first argument findstring
string searching. second argument text searching for.
read documentation next time: https://msdn.microsoft.com/en-us/library/ms141748.aspx
Comments
Post a Comment