I there anyway to automate the creation of the XSD file. Such that when the package runs every time it will create the XSD from the XML.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))