It happens. Whether it's a Border Patrol officer or CBP officer, land, airport or sea.

In the 17 Sep 2009 edition of the LA Times, there was an article regarding an ICE attache in Mexico who had just been arrested for investing in a cocaine smuggling scheme. He's also been charged with selling government files to traffickers, identifying undercover officers to the cartel and being involved with money laundering.