Hi , I am using a query for a transform data task.The
inner query takes 2 parameters but when i am trying to set
parameters it is saying access voilation.I do not want to
create stored procedure although it is working .Can anyone
tell me the way how to pass parameters to a inner query or
in union queries.
thanks & regards,
Prashant

Unfortunately the syntax support for (OLE-DB) parameters is rather limited.
A workaround -

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


--
Darren Green
http://www.sqldts.com

"Prashant" <anonymous (AT) discussions (DOT) microsoft.com> wrote