I’ve had a request from one of my regular blog followers couple of days back regarding a requirement.The requirement was to create a package which would enable exporting results of sql query to a flat file. The catch here was…
Generating Nested XML Structures with FOR XML PATH
This blog gives you some insight on how nested XML structures can be easily built using FOR XML PATH constructConsider the illustration given belowcreate table parent_child(ParentID varchar(50),ChildID varchar(50))insert parent_childvalues (‘Parent1′,’Child1’),(‘Parent1′,’Child2’),(‘Parent1′,’Child3’),(‘Parent4′,’Child4’),(‘Parent5′,’Child5’)The requirement was to built a xml structure as below The…
How to solve Microsoft.ACE.OLEDB.12.0 error “Unspecified error”
The reason for writing this blog is for the last 2 hours I’ve been battling with the below error message OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” returned message “Unspecified error”. Msg 7303, Level 16, State 1, Line 1…