Using a foreach loop to process an XML document.
Receintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn’t for the life of me get it to properly process the XML document which I was giving it. Well with some major work and digging I was able to get it working correctly, but it took me for ever to get all the little setting correct so I figured that I’d throw the info up here for anyone else who is looking for it.
Have a Happy New Year
Have a safe and happy new year.
Avoiding SQL Injection Attacks
The most common way for people to insert invalid data or cause damage to your database is through what is called a SQL Injection Attack. See how to protect your database and data against there potentially damaging attacks.
Microsoft SoCal Code Camp Comming Up
The Microsoft Code camp is coming upon us shortly. It’s a great excuse to head to Southern California and geek out for a few days.