I am trying to set up a simple database task. I have the connection string correct, but it gives me the error "Invalid Connection". Is this a permissions issue? Also, I want to create an Oracle task, but everytime I select the Oracle connection in the drop down and save it reverts back to a SQL Server option

The list you are talking about is just a example list of connnection strings. We are currently working on a new version which will help you further identify and test your string. You can go to http://www.connectionstrings.com  to try finding the exact connection string.

Remember that it is the textbox with the connection string that is important. Not the list above.

---

yes, I did select SQL Server (Standard) from the dropdown and I put the connection string in the textbox that should connect to my database, but when I try to test the job it is giving me Invalid Connection

SQL server (standard) is not refering to Oracle but MSSQL. Look here for Oracle connection strings:

http://www.connectionstrings.com/?carrier=oracle 

You have to cut/paste the connection string based on the provider (ODBC or OLEDB).

---