I am newbie to SSIS, i tried every effort to change the variable in olde db destination , but mapping of columns become issue.
i am stuck on it half a week., can u present specific example in it?
OPC.Three made a critically important comment above:
As long as the source csv file and destination tables are all the same schema it will work.
My version of this is: "If column definitions in either the source or the destination are different, for any of the files, it will not work"
It seems that you have fallen foul of this.
You will need a separate data flow for every different source file format you have. And for every destination table whose columns are different (by name or by type).
It's difficult to be more specific without understanding the source and target schemas better.
But the important lesson to take away is the SSIS is largely driven by meta data which is generated at design time. Dynamic column mapping / naming / typing is not an easy option.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.