SSIS - Connection manager working on preview but no working when running package

If you are trying to pull data and the connection manager is working fine and you are able to preview the tables from the database, but when you run the package it fails, the problem is the driver used to connect, it doesn't support 64 bit or you don't have a 64 bit installed.

You probably get errors like:

• Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider OraOLEDB.Oracle.1 is not registered -- perhaps no 64-bit provider is available.
• [Execute SQL Task] Error: Failed to acquire connection "NADCWDDBS01A_INS01A.LegalReview". Connection may not be configured correctly or you may not have the right permissions on this connection.
• Etc.

To solve the problem:

1. Go to your SSIS project properties
2. From Configuration properties select Debugging
3. On the Data Flow Optimizations change the option Run64BitRuntime to false

Error Starting Script Editor in SSIS 2005

If you are having a problem launching the design script from the script task editor in business intelligence development studio 2005, the solution is installing the "Microsoft SQL Server 2005 Service Pack 3 (KB955706)", this update fixes this issue.

This is the link to download the Microsoft SQL Server 2005 Service Pack 3 (KB955706)