I did a quick search and it seems that this is a known issue. Hopefully some of these links can help you out:

http://support.microsoft.com/kb/2009312

http://blogs.msdn.com/b/jorgepc/archive/2008/02/12/ssis-error-dts-e-cannotacquireconnectionfromconnectionmanager-when-connecting-to-oracle-data-source.aspx

Do you get the error when you execute the package in BIDS or with DTExec?

Can you connect to source and destination in BIDS/SSDT?

Are you running 32 bit or 64 bit SQL Server? If 64 bit, have you installed 32 and/or 64 bit Oracle Client?

How do you configure the account? You must use the SQL Server Configuration Manager.

Thanks Sean. Very interesting. Must take a closer look at the different reports.

Start/stop/restart requires membership in the sysadmin or serveradmin fixed server roles.

In Management Studio:

Right click on the database -> Tasks -> Backup...

Make your choices in the Back Up Database dialog box

Instead of clicking OK to start the back up, click in...

Notepad++ can also reload files on change: File Status Auto-Detection

As I tried to point out: You can download and install local help files in the Help Viewer. Help content can be downloaded directly from the Internet or by downloading...

You can still install local help files with Microsoft Help Viewer.

Check out http://msdn.microsoft.com/en-us/sqlserver/hh272029 for more information.

Thank you very much. This was really interesting.

You need to download and install 64 bit Access (Office) ODBC drivers separately. I don't have a link to a download page, but you can search for it.

Stupid font (no offence to the question author). I started looking for RangeL-N. :crazy:

Open the properties of the first job.

Select the Steps page.

Click New to add a step containing the second job.

SELECT TOP 1 ....... returns only one row