Tag Archives: XML

XML as Source in SSIS — Part 2

Now that our data is cleansed, onto loading the data into our table! The cleanest, most sane approach that I have found to parsing through XML within a SSIS script task is by utilizing Linq to XML. More information can … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

XML as Source in SSIS

XML is becoming increasingly popular in the workplace. Many systems are using it as a way to transmit data efficiently across the network. While XML certainly has its place, consuming it and deconstructing it can be a real headache. Unfortunately, … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Create XML Fragment in SQL Server

The XML datatype, first introduced in SQL Server 2005, can be very¬† handy when utilized properly. It is an industry standard, and with it, it is easy to import/export data across different servers, as well as different systems entirely. This … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off

Delete Multiple Connection Managers SSIS

Have you ever wanted to save yourself some time by copying a package, renaming it, and then modifying its contents to suit your needs? What if the package that you are copying from has 60 connection managers, and your new … Continue reading

Posted in Uncategorized | Tagged , | Comments Off