SQL + ODBC + Lotus Notes

I'm trying to write a "Stored Procedure" in SQL Server that will allow for the following:

1) Use of ODBC connection to Lotus Notes database. The data from a Notes 'view' will be used to INSERT INTO an SQL Table.

2) Select the Information from the Lotus Notes database view, and INSERT into the SQL Table.

So far, I think I've got the SQL "Select" and "Insert" statement set, but I cannot get the ODBC connection correct. Also not sure that my syntax is correct for the SP (CREATE PROCEDURE some_procedure)...