SSIS package with Variable which prompts while executing

Question

SSIS package with Variable which prompts while executing

Pulivarthi Sasidhar

SSCertifiable

Points: 6706
More actions
September 6, 2010 at 4:05 am

#141953

Hi,
I am new to SSIS.
My Scrpit is as follows
Declare @var VARACHAR(1)
IF @var='' or 'S'
Execute Proc_Test_S
IF @var='D'
Execute Proc_Test_D
IF @var='T'
Execute Proc_Test_T
Could you please give steps to complete this one.
While executing the Package it prompts for Variable @var.
I am going to add this package in SQL jobs and scheduling this one.
Please help me....
Thanks,
Sasidhar P

Viewing 4 posts - 1 through 3 (of 3 total)

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

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

Please explain - why are you using SSIS, when it seems that you are executing only T-SQL?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 2

Hi Phil,

Its NT Bacth Job....

I am going to convert it into SQL job.

While the Script does not prompt i/p value for executing corresponding Procedure if its by SQL job

If i creat SSIS package it will prompt i/p value for which procedure to execute.

I may give 'S' or 'D' or 'T' or '' based on my requirement....

Thanks,

Sasidhar P

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

I would suggest that using SSIS to prompt for user input is a bad idea and generally accepted as bad practice. There is a good likelihood of the job hanging at some point while it waits for a non-existent user to respond.

Better to prompt the user using more traditional 'front-end' methods (eg a .NET program) and then execute the SQL job from the program, passing the input parameter.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.