Business Data Catalog & Custom List

A new notes:

1. With Microsoft ® Business Data Catalog Definition Editor, there is need to manually change MethodInstance to Type "Finder";
2. Unless Single Signin is implemented, the ADF need to have 'RevertToSelf' as authentication mode rather than 'PassThrough';

3. make sure MOSS user have access to database used here;


Here is a link about using SSIS to importing data into sharepoint custom list:

http://www.onlinetechblog.com/blog/index.php/2009/07/how-import-data-to-sharepoint-list-using-ssis/