SSIS package with Variable which prompts while executing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS package with Variable which prompts...

SSIS package with Variable which prompts while executing

Rate Topic

Display Mode

Topic Options

Author

Message

Pulivarthi Sasidhar

Posted Monday, September 06, 2010 4:05 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870, Visits: 522

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

Post #980990

Phil Parkin

Posted Monday, September 06, 2010 4:09 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:33 AM
Points: 4,239, Visits: 9,483

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

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #980992

Pulivarthi Sasidhar

Posted Monday, September 06, 2010 4:15 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870, Visits: 522

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

Post #980994

Phil Parkin

Posted Monday, September 06, 2010 4:35 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:33 AM
Points: 4,239, Visits: 9,483

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.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #981006

« Prev Topic | Next Topic »

Permissions