The United Auto Workers union and Ford have agreed in principle to the terms of a tentative agreement that could signal the end to the nearly six-week strike with the Big Three automaker, sources with knowledge of the discussions confirmed Wednesday to CNBC.