August 1, 2008 at 7:43 am
hi,
would i be able to write sql statements in derived column task.
i have a column in one table that has 'y' and 'n' values i want to transfer these to second table but i want the values to be set to true if 'y' and false when 'n'.
can you suggest of away ???
thank you
August 1, 2008 at 7:51 am
Use the conditional statement in the derived column transfer.
value=="y" ? "true" : "false"
Remember that comparison in SSIS IS case-sensitive.
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
August 1, 2008 at 8:00 am
thanks for ur quick reply:
so what i do is say i have yesno column drag that from column in expression i have : [yesno], where do i insert you code...
August 1, 2008 at 8:40 am
^^ no worries i think i got it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply