Share via

ssis - output based on template

nononame2021 256 Reputation points
2022-06-16T04:16:00.05+00:00

i am preparing SSIS to output the variable into excel based on template as attached 211739-image.png

attached image highlighted in yellow color is a variable need to fill in and then output to excel.

how can i fill to specific column based on variable? for example, i need to fill in select count(*) from table to excel B6.

how can i output a excel based on template and fill in variable to cell B3, B4, B6 and B7 ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,736 Reputation points
    2022-06-16T05:21:48.447+00:00

    how can i fill to specific column based on variable?

    Your expected result in Excel is unstructured and unlogic in data terms; you can't expect a build-in function for "unlogical"; and so there isn't one.
    You have to use a .NET Script task to implement it.

    1 person found this answer helpful.
  2. ZoeHui-MSFT 36,661 Reputation points
    2022-06-16T06:12:48.77+00:00

    Hi @nononame2021 ,

    If you are good at C# or VB, you may consider to use Script task to do that.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.