ASP Page Run DTS Job ... variable

Last Post 09 Mar 2007 09:32 AM by GoodFella3993. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GoodFella3993
New Member
New Member

--
09 Mar 2007 09:32 AM
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 ...

SELECT *
FROM TBL
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.
You are not authorized to post a reply.

Acceptable Use Policy