Importing text files into a database is a common scenario. It gets more interesting though when you are required to import log files generated by ASP.NET’s health monitoring. We recently wrote a web application that receives and logs information via HTTP handlers. The logging was achieved using ASP.NET’s health monitoring. We wanted additional information to be included in the log entries however, so we implemented a custom event type by extending the WebRequestEvent base class. This allowe ... [Read more]

Scenario Recently a client had a requirement to upload documents to their SharePoint site. They wanted the ability to drop numerous files in a FTP folder and have them uploaded to SharePoint automatically. Solution We decided to solve this using a Custom SSIS Task that uploads files to the required Microsoft Office SharePoint Server 2007 (MOSS) Document Library. We therefore used the Integration Services Project under the Business Intelligence Project types within Microsoft Visual Studio ... [Read more]