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?
asked Jun 28, 2015 at 01:23 PM in Default
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.
answered Jun 28, 2015 at 03:08 PM