I want to have an ASP Web Page start off a DTS Job. I also want to have the web page to have a text box that will enter the value into the WHERE clause in the query of the transformation task that will create a text file.
In the sql query window of the Transformation Task, I will have something like this ...
WHERE CUSTOMER_ID = 5
I want the WHERE clause to be the variable from the ASP page however.
Is this set up under parameters?
WHERE CUSTOMER_ID = @@VARIABLE ?????
Any help is appreciated for I just started this project.