Hi,

I'm trying to create a DTS package using a Transform Data Task using the
following query:
"Select field1, ? from Table1 ". I want to pass a parameter inside my select
query so I can populate the destination with the parameter that I'm passing.

Is it possible to pass a parameter inside a select clause ? Everytime I do,
I get a parse error ?

I created a stored procedure that calls this DTS package thru the DTSRUn
command, I have designed previous DTS and it works if I use the parameters in
the "WHERE" clause.


Thanks,
Scott

Try building sql statement within ActiveX script using something like this:

set pkg = DTSGlobalVariables.parent
' Get DataPump CustomTask
Set stp = pkg.Steps("DTSStep_DTSDataPumpTask_1")
Set tsk = pkg.Tasks(stp.TaskName)
set oDataPump = tsk.CustomTask

' Build new SQL Statement
'sSQLStatement = "SELECT * FROM employee WHERE hire_date > '" &
DTSGlobalVariables("FilterDate").Value & "'"





"Scott Lam" wrote:

Have a look at this article


Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)




"Scott Lam" <Scott Lam (AT) discussions (DOT) microsoft.com> wrote