I don't know if I understand the possibilities of CLR. I thought, I could write a function that gets an SQL statement as parameter. In tn this function I want to execute the statement. Then I have to search for specific columns. When I find them I have to replace the values with
I'm using a VS SQL Server project to create a stored procedure. In that stored procedure, I want to load an SSIS package, set some of the package variables, and execute it. From the SSIS reference docs, that looks straightforward.