Post reply

Need SSIS package to get file from SharePoint

  • October 16, 2006 at 4:29 pm

    #153232

    Does anybody have a link or can explain how to build a SSIS package/project to use SharePoint site or just a Web as a source of data ?

    What I need is to build a package that would use Excel file located on S.P. as a data source. I just need to know how to connect to it, all the rest - how to process columns, set a destination, etc - is not in a scope of my question.

    Thanks

     

  • October 17, 2006 at 7:05 am

    #666190

    I believe that the SharePoint site is using a SQL server database to store the Excel file in a binary column of a table.

    In this case the 'export column' transform of SSIS can be used to extract the blob type data from the database and write them to the file system in their original format.

  • October 17, 2006 at 1:45 pm

    #666347

    Yes, that's right, SharePoint is using SQL Server database for its storage. But the problem is that SharePoint hides its SQL Server server name and other connection properties like database name , etc. When I browse SSIS connection for SQL Server server name I do not see anything that could be a SharePoint's server. Or there is a way to find it out ?

    Thanks

     

  • October 17, 2006 at 1:57 pm

    #666350

    I guess I have the advantage of knowing the server which is hosting the SharePoint. Once you find out which server it is, you can look in the %content% database for a 'Docs' table. This table will have the binary column holding the file you are looking for.

     

  • October 18, 2006 at 5:46 am

    #666437

    The only way I know of to get the name of the SQL Server hosting Sharepoint is to find the Sharepoint administrator and ask him/her for the SQL Server name, the database name and the table/column name.

    Sorry I couldn't be of more help.

     

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • October 18, 2006 at 3:51 pm

    #666674

    Thanks Brandie, I asked him but he has no idea about that.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply