Hi...
I'm trying to do a Transformation Task, but in my source query I have some
subqueries.
It works fine until I try to set a parameter (?) inside the query. I got the
"Send Error Report" error and the MMC is closed.
Why is it happening? Is it any known bug?
Thanks for helping!
Eduardo

Transformation Task is not very good with parameters if they are other then
for the where clause for the most outer select statement. What you can do is
pre-configure sql string in ActiveX task, assign it to a global variable,
and then assign that variable back to Transformation Task in Dynamic
Properties task.

Ilya

"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

....and an example of this an be found here-

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


Saying that, the use of parameters no matter how bad should not cause
Enterprise Manager to crash. You normally just get a syntax error.

Try applying SP3 to the client machine, followed by the latest SQL 2000
security fix. The fix patches a problem with the designer introduced by SP3.


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

"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote

Don't use subqueries take to much process, try to use join ...

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote