Permalink
Branch: master
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
9 lines (8 sloc) 624 Bytes
layout title date tags
post
Test your update scripts
2012-12-13 16:14:00 +0100
integration_test unit-test

This is a lesson I should have learned. It comes back to bite me and my coworkers ever so often. Running a script to update data without test is always quick and dirty. SSIS is a wonderful tool, but there are fundamental flaws to this tool as it's really hard to test SSIS packages. The beauty of using ruby or some other language (powershell, python, et.c.) is that you can write tests for the code. So, when you're doing yourself the favor of using ruby, write tests!