Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to download files from Sharepoint document library using ssis??
Posted

C#
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Linq;
using System.Web.Services;
using System.Net;
using System.Configuration.Assemblies;
using System.IO;
using Microsoft.SharePoint;
namespace ST_6b5adaed5fa4406a9edde7de4ac8c259.csproj
{
    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
    {

        #region VSTA generated code
        enum ScriptResults
        {
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
        };
        #endregion


        public void Main()
        {
            try
            {
                   using (SPSite oSite = new SPSite("http://servername/sitename/"))
                    {
                        using (SPWeb oWeb = oSite.OpenWeb())
                        {
                            SPList list = oWeb.Lists["listname"];

                            SPListItemCollection oItemCol = list.GetItems();
                            foreach (SPListItem oItem in oItemCol)
                            {
                                string strID = Convert.ToString(oItem["ID"]);
                                SPFolder folder = oWeb.Folders["Lists"].SubFolders["Tasks"].SubFolders["Attachments"].SubFolders[strID];
                                foreach (SPFile file in folder.Files)
                                {
                                    WebClient client1 = new WebClient();
                                    client1.Credentials = System.Net.CredentialCache.DefaultCredentials;
                                    FileStream outStream = new FileStream(@"C:\\destinationfolder\" + file.Name, FileMode.Create);
                                    byte[] fileData = file.OpenBinary();

                                    outStream.Write(fileData, 0, fileData.Count());
                                    outStream.Close();
                                }
                                
                            }
                        }
                    }
                //});
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            Dts.TaskResult = (int)ScriptResults.Success;
        }
    }
}


[Edit]
Code Blocks added.
[/Edit]
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900