However, generally speaking, the CMP sensor on a 2006 Dodge Durango is located on the passenger side (right side) of the engine, near the front. It's often mounted on the cylinder head, close to the camshaft. It's a small sensor with a single wire harness connector.
To be certain, consult your owner's manual or a repair manual specific to your Durango's engine. A quick online search for "[your engine size] 2006 Dodge Durango camshaft position sensor location" with images should also help you visually identify it.
Remember to be cautious when working near the engine; it can be hot.