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 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…