I recently built a stored procedure that uses a cursor to loop on a recordset of attorneys, builds a temporary view containing calendar events for each attorney, and exports that view to an external XML file. The temporary view and XML export code works, but I had to do some funky stuff with the code to get it to work. This made me start thinking about SSIS.
Is an XML export type of thing that SSIS is made for? Additionally, the sproc described above is just one of several in my project. Can I call an SSIS procedure from a TSQL sproc?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …