Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
- Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
- Restore SQL Server database using SAS from Azure Blob Storage
-
Recent Posts
Categories
Tag Archives: ORDINAL_POSITION
Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that … Continue reading