I'm speaking of this in the past tense, though I'm not sure if they still use the system.
In the 90's, Canadian National tried something similar to the Cargo Sprinter. This system, called the "Eco-Rail" system worked using special ultralight trailers and powered bogies which were pulled behind a purpose built "locomotive." I use the term locomotive in the loosest terms. The "locomotive" of the system had a regular coupling on the front of it, and could be pulled around by a standard CN engine. Due to numerous bugs, it often WAS pulled around this way.
On paper, CN hoped that the Eco-Rail system would free up locomotives from the trailer-train (road railers actually) intermodal service. Given the light weight of the trailers, it was expected that this lighter, self contained system, would be more economical, and "eco" friendly. Sadly, it wasn't.
By 1997, the system was experiencing a handful of crippling bugs, and though only two years out of the gate, the writing was already on the wall. One of the big problems faced by Eco-Rail, was the fact that the distributed power system didn't exactly work as designed. Intended to make the string of trailers operate as one train, nine times out of ten the distributed power would fail; causing the "locomotive" (which was under powered to begin with) to nearly grind to a halt. Thus, most photographs show the "locomotive" being pulled around by a GP9.
In the end, the longest train ever pulled by the system was all of 15 cars, and even then this was by a GP9 given the honors. At that point, CN had come to realize that the system was a bit more buggy than was worth the trouble, and though it had worked to begin with, the fact remained that double stack containers were becoming more popular at that point. Ultimately, ECO8004, ECO8003, the two locomotives, and ECO9004-9008, the four distributed power units, were quietly withdrawn from service. Their exact disposition is unknown, though scrapping is the most likely answer.
http://www.trainnet.org/libraries/Lib005/ECO8004.GIF
8004 with 9004 and 9005. DP units.
http://www.trainnet.org/Libraries/Lib005/ECORAIL2.JPG
8004 with 2 DP units being pulled by GP9 7066 after the lead DP unit suffered a heart attack.
http://www.northeast.railfan.net/images/tr_eco8003.jpg
8003 as she often was found in use.