I am looking for the best way to export a record in a table that has been saved as XML. I have available to me SSIS. What would be the best way to do this? Any pointers to webpages or articles would also be very helpful to me.
If it is really and Xml document saved in a column, then it should be as simple as creating an export package with a query like this:
WHERE <add your condition here>
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.