Abhijit More (4/3/2014)
We are saving mapping in below format. The other approach is saving it in vertical format.File NameCol1Col2Col3Col4
File 1.xlsField1Field2Field3Field4
File 2.csvField1Field3Field2Field4
File 3.xlsField4Field3Field2Field1
File 4.tabField2Field4Field3Field1
The only constraint we faced here is using mapping how to achieve it through SSIS?
To use this natively in SSIS you'd have to generate your SSIS packages (either programatically or by BIML).
You could use the mapping if you use .NET to transfer the data, using the SQLBulkCopy class.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP