cancel
Showing results for 
Search instead for 
Did you mean: 

How to use user selection parameter in the ssis package

Former Member
0 Kudos

Hello, The user is selecting category & time. of course in the dynamic script i have the prompt with %CATEGORY_SET% and %TIME_SET%. But the issue I am having is how to use these in SSIS Package tasks? please advise. thanks.    

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Zack

Which SSIS tasks in your package do you want to use. For example: If you want to pass a user entered value from a prompt in a data manager package to a Osoft task, you would put that in your dynamic script.

'DEBUG(ON)

PROMPT(TEXT,%MYVAR%,"Please enter a value",,"")

TASK(TaskName,TaskProperty,%MYVAR%)

If you want to pass a user entered value to a non Osoft task, then that will be slightly more tricky:

There are several approaches that you can use, you could try to use the

Global([variablename], [value]) syntax and in your SSIS package, you can try to retrieve the value using SSIS expressions to read the value of the variable.

You could alternatively  extract the value from the MODIFYSCRIPT variable. For example: All of the dynamic script gets stored in the MODIFYSCRIPT variable as text 'DEBUG(ON)<BR>MYVAR=VALUE<BR>...

Because it is a string value you could use a script task using string functions to extract the value and then do what ever you need to do with the value in the tasks you require.

It will get messy and cumbersome, but it is achievable 

Hope this helps

Kind Regards

Daniel

Answers (0)