SSIS Agent Job Passing Parameters

Question

Post reply

SSIS Agent Job Passing Parameters

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

chjquest Ten Centuries Points: 1174 More actions · Answer 1

To Steve,

Thanks for your post, it's a very great help.

Save me a bunch of money !

Cheers

Rasler

397229 SSC Enthusiast Points: 103 More actions · Answer 2

stevefromOZ - Friday, May 23, 2008 9:29 AM
Using a package level parameter, this works in SQLAgent --> \package.Variables[myVar].ValueHTH,Steve.

Thanks Steve, it helped me as well 🙂

Kind Rgds,
Sanjay

gauravjoshi.kec SSC Enthusiast Points: 166 More actions · Answer 3

Hi All,

Is there any way so that I can change the set values in sql agent job through TSQL.
Here is my case.
I have a job which runs SSIS package, ssis variable value is passed through step set value field.
I have to process data based on the rule written on sql and based on the rule I want to change the set value from the sql code.

Thanks in advance.

Gaurav

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Gaurav

Better to start a new topic for a new question. But I don't advise you to constantly change the job once it's set up. You should alter your package so that it picks up the value from a table. Your SQL code can then update the table, which is much easier (and requires lower permissions) than updating the job.

John