sqlbaby2 (4/2/2016)
In SSIS, how to write condition to split string value to different destination ? Example if type='Item' then go db a else db b. Thanks**Please delete the post as I already found the answer
..And for the benefit of others, the way to do this is to use the Conditional Split component, inside a data flow.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel