Hi,
I have built a package that takes data from a database, manipulates it and then creates a flat file. What I'm trying to do now is have the users kick off the package by entering an item# and facility# and then the package picks up this info and runs. I also need the flat file to be created with item#facility#.txt. I have created 3 variables for the item#, facility# and flatfilename but I'm not sure how to use the dtexecui utility to call the package, have the user enter the item# and facility#, pass this to the variables, run the package and then create the flat file name with the item# and facility# that was entered. I'm new to SSIS and never have used variables before to pass values into the package.
Thanks!
Isabelle