I get an error when I put comments at the top of my queries when trying to
set them up to use parameters. Without the comments, I don't. Even if the
comment is as simple as /* */, I get the error and it doesn't let me setup
the parameters. I can put the comments below the query with out getting the
error. Any ideas? Is there a patch that fixes this?

Thanks,
Rob

Hi Robert,

"Robert Hamilton" <RobertHamilton (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news82178B8-49F1-4B96-A843-8953BE25C2FB (AT) microsoft (DOT) com...
I'm afraid to say, thats the normal behaviour. The Command evaluation in
the DTS Designer only allows one command per step to use the parameter
and/or evaluation button.
And comments are also commands.
During runtime, this limitation doesn't exist. So you have to workaround
this by changing or even replacing the original statement with a dummy
statement to define the paramaters and the change the statement back.

HTH
Helge

Are you going against SQL Server?
Which task are you using?
Which SP of SQL Server?

I have just done this in an ExecuteSQL task pointing to SQL Server

/**/
SELECT 1 as 'One'

And I could run the query and populate a GV from it.

If you are referring to the DataPump task then yes this falls over. The
design time experience is delicate.

If you want to comment the task then you could use Annotations.

Allan

"Robert Hamilton" <RobertHamilton (AT) discussions (DOT) microsoft.com> wrote in
message news:RobertHamilton (AT) discussions (DOT) microsoft.com: