To use you have the ADO.NET-connection, young padawan

You set up a valid ODBC Data source in your ODBC-Administrator. Then, in the BIDS in your SSIS-package, you select "New ADO.NET-connection". Then you select ".NET Providers/ODBC data Provider". Now you should be able to see your ODBC-connection in the drop down-field at "Data source specification".