Blog Archives

Consuming JSON data in SQL Server and SSIS, convert JSON to XML

T SQL Date format convert function

Just came across very interesting scenario where I had to consume JSON data in SQL Server. Yes I can write C#/VB.net code and load JSON to SQL Server and go from there but what if I have no expertise in

Tagged with: , , , ,
Posted in SQL Server

unable to switch the encoding error with XML Data type

T SQL Date format convert function

If you ever tried to cast string to XML data type in SQL Server then you may encounter this error select cast(xmldata as XML) from XMLFiles Msg 9402, Level 16, State 1, Line 1 XML parsing: line 1, character 54,

Tagged with: , ,
Posted in SQL Server, T-SQL Tips