It is possible to do this, you need to look into creating a Data Processing Extension.

Try

http://msdn.microsoft.com/en-us/library/ms154655%28v=sql.105%29.aspx

to get started.