question

Ram-8513 avatar image
0 Votes"
Ram-8513 asked Monalv-msft edited

Transform Excel data using SSIS

Hello,

I have an excel sheet with data scattered across multiple cells. I need to transform the data into another well organized excel using SSIS. Please suggest me a good solution to tackle this.

Ex :
1) Product 01 - Product Name : A1, Product Cost : B2
2) Product 02 - Product Name : D3, Product Cost : E3
3) Product 03 - Product Name : B8, Product Cost : C8

I need to transform this kind of data into the following format.

All products under Row 'A' and corresponding cost values under 'B'

sql-server-transact-sqlsql-server-integration-servicesoffice-excel-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Ram-8513 ,

Could you please share the example excel source data and your desired output data?

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·

Hi @Ram-8513 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·

0 Answers