Recently, we had a server migration from 32 bit to 64 bit, once the transfer was complete, my packages developed in BID's started giving an error that read as "SQL Server Destination" failed the pre-execute phase and returned error code 0xC0202071. After searching for resolution I found help on Microsoft here http://support.microsoft.com/kb/2009672
To elaborate further, we can solve the problem as specified below:
In your BIDS open the solution explorer
Right Click on Solution Explorer and click on Properties
- Select "Debugging" from options on left and set Run64BitRuntime to false as shown below.
- Once complete Click OK and re-run the package.