asked
How to change the SqlStatementSource in a SSIS package through job step advanced tab?
I have a ssis package deployed and created a sql agent job which executes the package.I need to change the SqlStatementSource in one of the sql task in package through job step advanced tab. Can any one help me how to do that? I somewhere read its possible but not able to recall how exactly it can be done?
Try creating a parameter for your package and use expressions to assign it's value to the SqlStatementSource. In your job step, assign the desired value to this new parameter.
16 People are following this question.
