Its not odd it is the way it is designed to work.
As is, there is nothing you can do unless you use scripting in ssis and use c# .net
Its not odd it is the way it is designed to work.
As is, there is nothing you can do unless you use scripting in ssis and use c# .net