sql server data tools - How to Store return Output in variable in SSIS from Execute Process Task?

Question

Sample Python Code

# Get view content
variable = tm1.cubes.cells.execute_view(cube_name=mdx_view.cube, view_name=mdx_view.name)

# Print content
print(variable)

Here I am executing Python Code in "Execute Process Task" in SSIS. I am getting 12000 rows on the Console Window.

I have created a string variable named as "Output" Basically above python scripts pulls a table and store it in "Variable" Object and prints it on console. I want to store that data in SSIS and perform ETL Transformations.

Can someone guide me what approach should I follow ? How should I store data in variable. I did went through forums but didn't find anything substantial.

question from:https://stackoverflow.com/questions/66064868/how-to-store-return-output-in-variable-in-ssis-from-execute-process-task

Answer 1

Waitting for answers