On 10 December 1891, Schwartzkoppen was appointed as military attaché at the Embassy of the German Empire in Paris, maintaining relations with the French Republic. It was his second diplomatic posting to Paris. In addition to performing formal representational and liaison duties, his subsidiary task was to obtain secret information on the French Army without the knowledge of the German ambassador resident in Paris. Instead, Schwartzkoppen reported directly and in confidence to the Director of Military Intelligence in Berlin. As a result of his spying, he became involved in the Dreyfus Affair. In 1894, he received an anonymous offer for the purchase of rather insignificant military intelligence, outlined in an unsigned bordereau. The torn paper, supposedly in the handwriting of Alfred Dreyfus, was recovered from Schwartzkoppen's wastebasket by a French cleaning woman on September 25 and became the key evidence of Dreyfus's conviction for treason. Serious doubts regarding the guilt of Dreyfus were raised during his trial. Later investigations showed that Schwartzkoppen was receiving intelligence not from Dreyfus but another French officer, Ferdinand Walsin Esterhazy. Schwartzkoppen himself confirmed Dreyfus's innocence in his memoirs, which were published posthumously in 1930. In the 1890s, Schwartzkoppen had an affair with Hermance de Weede, the wife of the Counsellor at the Dutch Embassy in Paris, and a large number of their letters were intercepted by the authorities. Also intercepted was the correspondence between Schwartzkoppen and a popular figure in Parisian diplomatic circles - the Italian military attaché, Lieutenant Colonel Count Alessandro Panizzardi. Italy and Imperial Germany were then formally linked under the Triple Alliance of 1882 and letters between the two attachés record that they freely exchanged intelligence and cooperated on espionage matters. The letters also contain passionate and erotic endearments which indicate that they too were having an affair. The Schwartzkoppen and Panizzardi material was withheld from the Dreyfus defence team in 1894 but was later discussed in a closed session during the 1899 retrial. While neither officer had anything to do with Dreyfus, the correspondence lent an air of truth to other documents that were forged by prosecutors to lend retroactive credibility to Dreyfus's conviction as a spy. Some of the forgeries even referenced the apparent affair between the two officers. In one, Alessandro supposedly informs Panizzardi that if "Dreyfus is brought in for questioning", they must both claim that they "never had any dealings with that Jew.... Clearly, no one can ever know what happened with him". The letters, real and fake, provided a convenient excuse for placing the entire Dreyfus dossier under seal because the exposure of the liaison would have "dishonoured" the German and Italian militaries and compromised diplomatic relations.
In 1897, while the Dreyfus Affair was still at its height, Schwartzkoppen was recalled from his diplomatic posting in Paris to take up command of the 2nd Kaiser Franz Ferdinand Regiment of Grenadiers. In 1902, he married Luise Grafin von Wedel with whom he subsequently had two daughters. Promoted to the rank of general in 1907, Schwartzkoppen retired from the army the following year, moving to his country estate in the Altmark. With the outbreak of war in August 1914, General Schwartzkoppen returned to active service. He commanded the 233rd Infantry Brigade in France, before being appointed in 1916 to lead the 202nd Infantry Division on the Russian Front. Suffering from pneumonia, he was hospitalized in Berlin. While delirious, he reportedly blurted out, "Listen to me. Dreyfus is innocent. There is no evidence whatsoever against him". His wife, seated at his side, made a written record of this statement. Schwartzkoppen did not recover and died on 8 January 1917.
Personality
Schwartzkoppen was described as being a cultivated officer with considerable social charm; characteristics which suited him for the diplomatic and Imperial Court functions that made up much of his military career.