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?