I created an ODBC to Lotus notes server and database.  This ODBC connection works, however, when I put the ODBC into SSIS and test the connection my visual studio 2010 crashes and has to restart.  Is there a fix I am missing on my VS2010?  Or am I doing something wrong in my SSIS project?

Please tell about the driver you used for it. And I think the fix is in using the 32 bit version of the driver.

Hi Kathy,

To check whether this issue is related to ODBC or VS IDE, I suggest you could create the same ODBC Connection Manager on other machine to check if you can still get the same issue.

• If the issue still exist, then the issue should be related to ODBC Connection string. Please post the detail steps about how did you create the ODBC, then we can make further analysis.
• If the testing successfully, then the issue should be related to the VS IDE. Please recreate the ODBC, restart the machine and run the VS as Administrator to test again on your original machine. If it still exist, please post the issue to VS forum for better support.

Thanks,
Katherine Xiong