Lets assume a scenario…You are a BI guy of your team and your company has just started working on a business case where there is a requirement for a non-proprietary data. For example assume that your company is making an asset management system...

  I have recently worked on a problem where we come across a situation such as the following: You are working on a solution using SQL Server Integration Services(Visual Studio 2005). You are pulling data from your database and trying to place the...

PROBLEM DECRIPTION While executing a BULK INSERT command from a remote connection the following error is reported: Msg 4861, Level 16, State 1, Line 6 Cannot bulk load because the file " \\sqlbox\share\myText.txt " could not be opened. Operating...

Just came across this great piece of work from PragmaticWorks. Product description @ http://www.pragmaticworks.com/dtsxchange.htm : “The built-in wizard to migrate DTS packages is approximately 40% successful and does not allow you to enjoy the...

I ran into this error somehow. 'Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..' SQL Server error logs have the following logged. ERROR From SQL Server Error Log 2008-11-18 21:57:50.82 server Error: 17882, Severity...

  Problem   Your ASP.NET Web-site times out during production with the following error: Errors   Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 8/27/2008 Time: 5:48:43 PM User: N/A Computer...

I just received two back to back cases on the SQL Injection attacks today. I found that attackers have targeted a large number of sites.   In both the cases ASP is the targeted technology but I don’t think weakly designed ASP.NET sites are...

I started with a nobel idea of sharing my codes and decided to set the Source Control for Visual Studio 2005. I configuired VSS for Remote (Internet) Access and just when I thought it's over I ended up here: I could open a project and can 'check...

Problem: You may not able to browse Reports after installing and uninstalling the MOM reporting. And you may get the following error message in SQL Reporting Service log files w3wp!extensionfactory!1!01/30/2008-13:37:53:: e ERROR: Exception caught...

A simple routine to test XML validation of MSXML4 Parser Note: Do include "Microsoft XML, v4.0" in Project --> References Private Function Validate( ByVal strXMLPath As String , ByVal strXSDPath As String ) As Boolean Dim objSchemas...

PLAN: 1. Drop a ReportViewerControl to your favourite webform 2. Drop a new DataSet in the project (DataSet1) 3. Create a DataTable in DataSet's XSD (DataSet1.xsd) which should define the structure of <Books.xml> I created Table1 which...

1. Click Start, point to Programs, click to select Administrative Tools, and then click Internet Services Manager. 2. Expand the server name. 3. Expand Default Web Site, 4. Right Click on reports Virtual Directory and go to properties 5...

In this project we will try to make a report which can use a dynamic connection to a Northwind Catalog hosted in different SQL Servers. This report is going to query the Employee Table in Northwind Database for the following fields: · EmployeeID...

There are 2 methods to achieve this 1. Modify ReportingServices.js in "Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\js" 2. Create a frontend HTML page which forces the Report Manager to Open in Full Screen Mode...

READING CONECTION STRINGS FROM A APP.CONFIG FILE Step1. Add System.Configuration namespace in the add reference section Step 2. Add the following line in the import section using System.Configuration; Step 3. Add the connection...

Problem: You may see the following error while browsing the reports in SQL Server 2005 Reporting Service: Error Code: 500 Internal Server Error. The request was rejected by the HTTP filter. Contact the server administrator. (12217) We have...