Import Data Using SSIS and Transposing Columns to Rows
In this tip we look at how we can create an SSIS package to transpose multiple columns for a record and inport multiple rows into the database.
Balamurugan Loganathan has an engineering degree in IT and 13 years of experience in Data Warehousing and Business Intelligence space predominantly using SQL Server, Teradata and Cognos BI. He has 10 years of experience working for Financial Services in the UK. His areas of interest are SQL Server Performance Tuning, SSIS, MDX and Power BI. He can be contacted at balasqlanalytics@gmail.com and on linkedIN at www.linkedin.com/in/balamurugan-loganathan-1133b925.