September 6, 2010 at 4:05 am
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
September 6, 2010 at 4:09 am
Please explain - why are you using SSIS, when it seems that you are executing only T-SQL?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 6, 2010 at 4:15 am
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
September 6, 2010 at 4:35 am
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply