An Avanade Blogging Community

I always hesitate to write about anything involving someone else’s code, lest the favor get returned.  In this case however, one must have some sympathy for the developer, as the source system for a particular ETL job was not yet in production.  Read More

The XML data source does not handle complexity within XML very well. For the simplest XML it is fine, but for anything that is complex – in other words, real world data – one needs to resort to Script tasks or executables to actually get to data. Whenever you see “” you can be sure you will have issues with the XML data source. Read More

Fair warning:  Folks may find this too “political.”  I think this needs to be said, but if you are easily offended, then please stop reading now.   I was extremely surprised – shocked is probably a better word - to find this quote in Read More

One of the most convenient features of SSIS is its ability to create and load flat file sources. In particular, this allows a developer to dump “bad” or non-conforming data into a flat file that can be used to fix data issues at a later date or otherwise log mistakes and cover the technical person’s derriere. Read More

I recently spent a rather frustrating few days battling a feature in the OLE DB configuration in SSIS.    I created a SSIS package to export from an Oracle database and load into SQL Server.  Following my usual practice, I created an Read More