BUG: DTS Query Builder Problem with Inline Comment

SYMPTOMS

The SQL Enterprise Manager Data Transformation Services (DTS) Query Builder does not correctly build an SQL statement that begins with the SQL Server inline comment '--'. Every line after the comment is treated as part of the comment. The Query Builder does not recognize that the comment ends on the same line that contained the '--' inline comment marker. For example, if you typed the query

select * from titles
where title_id > 'B'
-- here's my comment
AND price > 11.00
				

And then you clicked Build Query, you would only see the following:

select * from titles
where title_id > 'B'
				

The inline comment and any subsequent lines are all treated as part of the comment.

-- This is a comment
				

/* This is a comment */