Dec 15, 2020 · Select Connection: Select an existing SharePoint Connection Manager or choose to create a new one. Select List: Once your connection manager is set, choose a list from your SharePoint server. Select View (optional) Choose the view to use for the chosen list. Download Attachments Jan 06, 2014 · <p>During the last 3 months, I used 32 bit SSIS 2008 (v 10.50.2500.0) on an WinXp machine (v 5.1.2600 SP3 Build 2600) to create a package that writes multiple query results (reports) to an excel spreadsheet.
Expand the SQL Server Agent node, right-click on Proxies, and click on New Proxy... Step 4: Enter Proxy Information and Assign Proxy Give the proxy a name, assign it the Credential you created, optionally give it a description, and assign it to the SQL Server Integration Service Package subsystem.