ALARM! ALARM!

I keep falling into this trap. We use SQL Server 2008 and if there's one thing it can't tolerate is using comments and parameters in the same SQL query inside SSIS.

When compiling the queries to send to the Server it seems to get rid of newlines while processing the parameters. The result is:
SELECT [Name]
FROM [NameTable] --Comment
WHERE [id] = ?

becomes
SELECT [Name]
FROM [NameTable] --CommentWHERE [id] = ?

Multiline comment blocks seem to work ok, presumably because they have a closing */

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
BBCode format allowed