x

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?

more ▼

asked Jun 28, 2015 at 01:23 PM in Default

avatar image

jaijitendra
1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 28, 2015 at 03:08 PM

avatar image

Alvin Ramard
1.4k 2 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x242

asked: Jun 28, 2015 at 01:23 PM

Seen: 226 times

Last Updated: Jun 28, 2015 at 03:08 PM

Copyright 2017 Redgate Software. Privacy Policy