This project has moved and is read-only. For the latest updates, please go here.

Error generating Execute SQL task

Jul 25, 2013 at 9: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 10: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 ?
Jul 25, 2013 at 1:20 PM
Have you tried just using xml encoding - <>
Jul 25, 2013 at 3: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