.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Migrate DB + files outside DB into SharePoint using SSIS and scripts

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....

So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.  

Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...

Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!



View Complete Post

More Related Resource Links

Use SSIS to read files in SharePoint library

Hi,I'm trying to use SSIS to read data from an Excel file in a SharePoint document library and I am having some problems with it.First I tried to use the Excel file as a source file in an Excel Source task which worked well in BIDS but not on the SQL server. ("CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER")Next I tried to read data from an Excel file on the SQL server file system which worked well on the SQL server.Next I tried to use a File System Task to copy the Excel file to the SQL server file system. This also worked well in BIDS but not on the SQL server. ("The file name \\sharepoint\mylibrary\myfile.xls specified in the connection was not valid.")I have also tried to let the SQL server agent run on a domain account that is set up as a reader on the SharePoint document library without success.Where am I going wrong?

Import multiple xml files(sharepoint webservices out put) to sql database using ssis



I am importing xml file in to sql server database i was able to do this task for single xml file in to sql database using ssis( i am using dataflow task, xml source, data conversion, oledb destination creating a ssis package).

Now i am having 3 xml files, need to store in different tables in sql server database can someone explain how i can import multiple xml files in to different tables in sql.can we create a xsd for each xml file while importing.

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Add edit drop down menu so I can edit pdf files in SharePoint


I have a pdf file that I'd like to open and edit.  The pdf file just opens, and doesn't ask if it should be opened as a read only or edit option.  My colleague is able to select edit mode as a drill down, but I can't figure out how to add this functionality into my document library... does anyone have a solution?

sharepoint search pdf files using metadata and also the content inside pdf

I am a novice to sharepoint search can anyone give some ideas on how to integrate search at a subsite level (only to that subsite) which has pdf documents with metadata associated with it the search should also search the content within the pdf and libraries and list metatdata in Moss 2007

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

Storing .EXE Files in SharePoint



   New to SharePoint.  We just started migrating directories to our SharePoint server, and have encountered an issue storing .EXE files.  The error message says that it is denied by the administrator, however our IT team believes you can not store .EXE in SharePoint and that it is a system limitation.

   Could someone please confirm whether or not there is a restriction for the storage of .EXE files in SharePoint?  

   If this is just an administrator setup issue, is there a doc that would direct us how to remore this setting?

Thank you,


Download the PowerPoint Files Used in Sessions During the SharePoint Conference

View PowerPoint files that represent a selection of the ten most popular SharePoint 2010 and Office 2010 developer track sessions at the conference.

Video: Rendering SharePoint 2010 Media Files in Silverlight

This demonstration illustrates how to render SharePoint media files in a Silverlight application. (Length: 11:28)

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

Updating Config Files in Sharepoint Farm

I am trying to update config files web.comnfig in the Virtual Directory of my server so that users are allowed to upload more that 50 MB of files in my IIS 7 server. Everytime i do the update it works fine but after few days when there are few changes then it removes the added elements itself and restore in the Original Stage. I used to edit my config files manually. I found a way of creating a config files and saving it to the Config Directory under 12 Hive in Server. Like the Content will be similar as follows <actions>    <add path="configuration/SharePoint/SafeControls">       <SafeControl          Assembly="System.Web, Version=1.0.5000.0, Culture=neutral,             PublicKeyToken=b03f5f7f11d50a3a"          Namespace="System.Web.UI.WebControls"          TypeName="*"          Safe="True"/>    </add>   </actions> I have to add following line <system.webServer>     <security>       <requestFiltering>         <requestLimits maxAllowedCon

Not always prompted for read-only or EDIT mode, when opening files with IE7, Sharepoint 3.0

Hello Everyone,   We use Sharepoint 3.0 and when I click on a document I get a pop up prompt that asks me whether I want to open the file in READ-ONLY or EDIT mode.   I use a machine with XP Pro that is running IE7.   A user called me today, also running IE7, and when he clicks to open a Sharepoint file he gets a different prompt - a simpler one that just offers OPEN or SAVE.   I don't care that his prompt looks different - the problem is that he is able to open the file, make edits, but then when he closes the file (using Excel) he isn't able to save his changes.   Excel only provides a save-as option for him.   This isn't a permission problem with his ID.   When I login to our Sharepoint 3.0 system as him, with his password (from my machine), I get the usual Read-Only / Edit prompt and when I open a file in EDIT mode I am able to save my changes with no problem.   Any thoughts on this?   Chris

Playing video files in sharepoint

I uploaded Media file in sharepoint site. When click on video file, Windows media player open in my machine and got an error saying "Windows media player encountered a problem while playing a file". I have the same file in my local machine. It is playing fine. Only I have from sharepoint site.   Can some explain and solve the problem please? ItsMeSri

SharePoint crawl errors on files which are not present

All, I'm noticing 2 errors in my crawl logs. Neither of the files exist anywhere on our site. The URLs are http://.../forms/repair.aspx and http://.../forms/combine.aspx and the error message is 'Error in the Microsoft Windows SharePoint Services Protocol Handler'. Our crawl normally takes about 3 and a half hours. Recently, it's been taking 5-6 hours. These 2 errors are logged at the end of the crawl. While the crawl is running, I see the success count growing and at about 3 and a half hours into the process, the success count stops growing. I'm not sure what the crawl is doing for the next 2 or so hours, but if finally logs the 2 errors mentioned earlier at the end of the crawl, then completes. I have tried resetting the crawled content and changing the index location of the SSP, but neither have worked.  I have also tried excluding the path to these two files with crawl rules, but that hasn't worked. I am on SharePoint 2007 SP2. Any ideas? Thanks

MissingIDLog files in SharePoint 2007 indexing server

Hello, We have configured sharepoint  2007 server to crawl lotus notes databases.  The problem is huge number of MissingIDLog.txt files are generating daily in root directory(C:\) of indexing server and these files are of 0Kb. How to stop these MissingIDLog.txt files? Regards, Gireesh  

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend