'How do I use Python(pandas) to restructure a table in SSIS
So I'm using an ETL tool(SSIS) for the first time and I have a problem. I will try to give a simplified version of the problem I encountred so that it makes it more understandable.
Let's suppose that I have an Excel table in which the first column is an ID of an employer and then for the next 10 columns I have the value of the salary of the employer for the last 10 years:
What I want to do is load this excel Table into a database table that has only three columns which are ID, year and salary so I want to get a result like this:
My question is: I've seen that I can add pyhton scripts to SSIS so can I extract the data from the excel file then transform it using pandas in python before loading it to the table? and if not how should I proceed?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|