I got a task where I need to pull data from a sharepoint list via SSIS package. By default, there is no provision to connect to sharepoint list. But, you can download the adapters from codeplex: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
I have installed SSIS Sharepoint list adapters for SQL Server 2005. After you install the adapters, launch the SSIS BIDS. Create a new package. Open the Package window. Select the ‘Data Flow’ tab. In the left navigation, select the ‘Data Flow Sources’, right click and choose items. You will see a dialog window as shown below, where you can select the Sharepoint list source and destination adapters.
Now, after selecting the sharepoint list source and destination adapters, click on the Ok button. The adpaters will now appear on the toolbox as shown below,
thats all! now you can connect to sharepoint list via SSIS.
The ‘SEHException was unhandled by user code (External component has thrown an exception) ‘ was displayed in my WPF application at runtime as shown below,
This happened in a line of code which tries to create an instance of a class. After analyzing, I found that, the particular .xaml page loads videos and the necessary codec is not installed. So, after installing the codec (klcodec490f) and restarting the system, the WPF application worked fine.