I need some help with some SQL as for what is supported in regards to <commandText> section of the database target. I have a command that does multiple table inserts, but in one particular condition I want it to not insert. Please see the following:
IF @ID IS NOT NULL AND @ID <> ''
INSERT INTO EventAttribute ([EventID], [Attribute], [Value])
VALUES (@iEventID, 'ID', @CmhcID);
There is an error on encoding..The limitation for the 'not equal' <> is more of a XML encoding limitation I suppose, and for the life of me I can think of a workaround.