iamsql1 (2/4/2013)
Hi PhillI 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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.