Error generating Execute SQL task

Jul 25, 2013 at 8:31 AM
I get an error "Name cannot begin with the '>' character, while generating pacakges with Exceute SQL statements. The error points to a line that is not present in the BIML script.
Jul 25, 2013 at 9:02 AM
looks like the error is generated by a part of the SQL statement containing <>. Now looking for a way to work around this. Any guesses ? perhaps using CDATA ?
Coordinator
Jul 25, 2013 at 12:20 PM
Have you tried just using xml encoding - <>
Jul 25, 2013 at 2:29 PM
You have two options. Either use the XML escape codes or rap the SQL in a CDATA tag.
Marked as answer by furmangg on 3/17/2015 at 6:23 PM