I cannot find an article for the life of me that explains what I want to do, which seems so simple to me.
We have an SSIS package we use to run some processes against our SQL server 2008. Each time we run it, we need to edit some of the SQL to change codes for various things.
I would think I could write a VB.net data entry screen that would allow the user to choose the file he wants to process, enter the couple of codes he needs, and VB.net would hand those values to the defined variables inside SSIS. Or, use the script tool in SSIS in VB mode to pop up a data entry screen (maybe pre written in VB and copy pasted) that would do the same thing?
I cannot find any articled or forum posts discussing how this can be done. Can it?, if so, do you have a reference?