• Well, you could store the used configurations in string variables and then write the values of those variables to a text file using a script task.

    Or, you can store the values of those variables in a temporary table using an Execute SQL Task.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP