Hi,
I am writing a DTS package to get data from Teradata. It seems like Teradata
driver does not support parameters. I need to pass parameter to the query.
Is it possible to write ActiveX to substitute query parameters from global
variables?
Please give me the steps how to do it. Also, should I use data Driven Query
or Execute Sql Task?
Thanks in advance,

[quoted text, click to view]

Hi Ashish,

Are you using SSIS or DTS? In SSIS you can set the SQL Statement in
your Data Source task by choosing one of the "Table or view from
variable" Data Access Modes. If I remember correctly (although it has
been a few years) in DTS2000 you can use the Dynamic Properties
Assignment task to accomplish the same thing. Alternatively you could
use an ActiveX script task in DTS2000 as well, but it is easier to
just use the Dynamic Properties task.

Good luck
J