Popup to ask variable value every time it run
-
In my project there is a simple select query whose 'where' condition will filter for particular records for a company which is having one ID.This where condition is actually ask for companyID.
I want that a pop-up should ask this ID in SSIS and attach this in 'where'condition so that, user has to give this ID and get the result.
Please help me
-
vivekjamshedpur (12/9/2009)
In my project there is a simple select query whose 'where' condition will filter for particular records for a company which is having one ID.This where condition is actually ask for companyID.I want that a pop-up should ask this ID in SSIS and attach this in 'where'condition so that, user has to give this ID and get the result.
Please help me
You can create create simple script and use InputBox function to get input and then store the input into a package variable to be used in your WHERE clause.
The question is why would you want to do that? If you implement your package in this way you will not be able to schedule your package for execution from SQL Job Agent. The better approach would be to supply a variable value with configuration file.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply