2008 Pacifica fog lamps wire activation
 

I just got this my second Pacifica and my previous had foglamps(no problems there), but my 2008 did not have. I located the foglamp wire terminals ( wire harness to connect foglamps) but there's no power to the terminals. My issue is how to get power to the wire for the foglamps, since there's no switch and I don't know how to find the source to attach the wire and get power to it.

You should be able to purchase just the headlight/turn signal/combo switch. This would be a straight forward replacement for the current one in your Pac. There are several writeups on the forum for installing fog lights. Yours being prewired makes the job simple.