Caffarra was named Archbishop of Ferrara-Comacchio on 8 September 1995, and consecrated on 21 October 1995 in the Cathedral of Fidenza by Giacomo Biffi, Archbishop of Bologna. He was installed on 4 November. Caffarra was appointed Archbishop of the Bologna on 16 December 2003 and installed there on 15 February 2004. Caffarra was a noted opponent of contraception. In 1988, Caffarra weighed the sin of condom use against acquiring the AIDS virus: "Even the smallest moral wrong is so much greater than any physical wrong. I know this is hard for some to accept when the dangers are great, but the church is here to combat moral wrongs." The next year, Caffarra argued condom campaigns further exposed society to AIDS because "the means of protection are far from reliable".
Cardinal
In the consistory of 24 March 2006, Pope Benedict XVI named Caffarra Cardinal-Priest of S. Ioannis Baptistae Florentinorum. On 7 May 2006 he was made a member of the Congregation for the Evangelization of Peoples and the Executive Committee of the Pontifical Council for the Family. He was identified at the time as "a strong conservative" voice for the opposition of the Catholic Church to the modern world and one of Benedict XVI's less centrist appointments to the College of Cardinals. In a note Caffarra published on 14 February 2010, he wrote "public officials who openly support same-sex marriage cannot consider themselves to be Catholic". He said: "It is impossible for the Catholic faith and support for putting homosexual unions on equal footing with marriage to coexist in one's conscience – the two contradict each other." He participated as a cardinal elector in the 2013 papal conclave that elected Pope Francis. Pope Francis named him to participate in the Synod on the Family in October 2014, in advance of which Caffarra authored an essay that argued that Catholics who divorce and remarry must be denied access to the Eucharist because their situation "is in objective contradiction with that bond of love that unites Christ and the church, which is signified and actualized by the Eucharist". Allowing them access would mean the Church recognize their extramarital sexual relations as legitimate and contradict Church doctrine on the indissolubility of marriage. When accused of opposing Pope Francis with that essay, he called the statement a "slander" and said he would rather be charged with taking a lover than harboring views not shared by the pope. On 26 September 2015, Pope Francis appointed Caffarra to a five-year term as a member of the Congregation for the Causes of Saints. His resignation as archbishop was accepted on 27 October 2015. In September 2016, Caffarra and three other cardinals publicly asked to Pope Francis to clarify five points of doctrine in the Pope's apostolic exhortation, Amoris laetitia. They issued this public letter after the Pope did not reply to the same query made privately. In June 2017, Caffarra wrote on behalf of the four asking Francis for an audience to discuss their questions. He said that varying interpretations were producing inconsistency: "What is sin in Poland is good in Germany, that what is prohibited in the Archdiocese of Philadelphia is permitted in Malta." Caffarra died on 6 September 2017 after a long illness.