The opening of the floodgate attracted hundreds of local and foreign tourists who came to witness the rare spectacle , which last took place in 2002 , the Zambia National Broadcasting Corporation reports .