I'm in the process of converting from DTS to SSIS. Overall the migrated packages have done quite well. One issue I'm having problems understanding is how to allow entry of variables at run time. We have power users that previously ran dtsrunui.exe (now dtexecui.exe). They don't have BIDS or Management Studio. What are some methods of allowing entry of a database name or a date and other package variables to populate package variables? I keep reading that package configurations are the way to go, but if I understand the way they work, you have to open the XML file, modify the values of the parameters and then run the package. That is complicated and klunky for a power user to have to do.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSIS Newbie - Variables and Package Configurations
- Thread starter tmunson99
- Start date
you can store the needed variable values in a SQL table and allow the change to take place there. I believe if the run the package from SSIS in SSMS they can enter values there (Haven't tried it).
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question