February 13, 2009 at 4:27 pm
🙂
I am new to SSIS and need some help.
I am needing of checking a field from a flat file for zeroes in it. if zeroes are found I wish to format the resulting field as "0001/00/00".
I was told of the IFF instruction or command but I do not know how to use it.
Does any one have any pointer for a novice. Is there a link somewhere that would provide examples of usage of these instructions? I see many, many formats but I am unable to decipher which one is the appropriate one for use with SSIS.
Please help.
Thank You.
February 16, 2009 at 7:52 am
Here is a link to how to use the Conditional expression in SSIS, http://msdn.microsoft.com/en-us/library/ms141680.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply