I found a solution. I thought I would post it here since this has taken me a few weeks off and on to fix.
In Windows Server 2008 you must first create a windows scheduled task that executes the file. Under performance monitor, in your data collector you specify the task name there. If anyone is having this same issue I can go into more details.
Adam Durr
Remote DBA support
www.bluegecko.net