|
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Bechir Bejaoui
|
Rating:
|
|

In this article, I will show how to connect to a Data reader destination component within a given SQL Server Integration Services package. The client application in this context is a simple console application that I have built using C# 3.5....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Santosh Benjamin
|
Rating:
|
|

BizUnit is a very extensible testing framework. One of the core elements of BizUnit is the Context object. Unfortunately, the documentation does not explain how users can take advantage of it, and it is left to developers to try and understand it from some of the code snippets provided in the NDoc documentation....
|
|
|
|
Total Hits: 0 | Today: 0
|
Author: Christian Thilmany
|
Rating:
|
|

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information. The sample app presented here uses updategrams to make the database updates. To accomplish this, the mapping and usage of updategrams...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: kishore Gaddam
|
Rating:
|
|

In the last 14 years of my programming experience, i moved from waterfall methodology of software development to Iterative and then to Scrum and finally to Scrum-ban. Below is the pictorial representation of the Waterfall, Iterative and Scrum software development process. More info about Kanban and Scrum-ban will be posted in my upcoming blogs. In this article, i would like to demo on how to use the Microsoft Visual Studio Scrum 1.0, process template built specifically for Scrum teams...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Thomas Weller
|
Rating:
|
|

In contrary to what I initially stated in this post, Moles is not only available as part of the Pex framework, but also stand-alone on Visual Studio Gallery, and this is completely free (no MSDN subscription required). - Thanks to Peli for the correction......
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Thomas Weller
|
Rating:
|
|

In contrary to what I initially stated in this post, Moles is not only available as part of the Pex framework, but also stand-alone on Visual Studio Gallery, and this is completely free (no MSDN subscription required). - Thanks to Peli for the correction......
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Alice Julia
|
Rating:
|
|

This corruption is caused by a timing issue in the Host Integration Server 2004 Managed Provider for DB2....
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: santosh poojari
|
Rating:
|
|

I got a task to develop the web page that execute SQL server 2005 SSIS package. With less knowledge of SSIS it was difficult for me to get the solution right at first time. But with online help I was able to crack the problem. I created a simple DTSX package which takes spreadsheet data and pumps it into a database table and then I execute store procedure inside the package to perform manipulation in database table. These whole bunch of process are then executed through asp.net. Below I have dem...
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: Brad McGehee
|
Rating:
|
|

Because of the nature of SQL Server 2000 clustering, you want to ensure that it is as reliable as possible. One of the ways to help ensure that is to be sure that you have installed the latest SQL Server 2000 Service Pack on the SQL Server 2000 Cluster before you put it into production. Its installation requires a reboot of both nodes, and adding the service pack now, rather than later, can reduce potential downtime later on....
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|

Database Administrators often get requests from development teams to deploy and schedule newly created SQL Server Integration Services (SSIS) packages across different environments. In this article you will see the steps that you need to follow in order to schedule an SSIS package as a SQL Server Agent Job using SQL Server Management Studio (SSMS). SQL Server Agent Jobs can be used to schedule and execute SSIS Packages which are stored in SQL Server, or in File System, or in the SSIS Package sto...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|

It is a very common task for Database Administrators these days to import SQL Server Integration Services Packages from one instance of SQL Server or from a File system into a local instance of SQL Server when setting up different environments to support applications. In this article you will see the steps which you need to follow in order to import a SQL Server Integration Services Package that is stored in an instance of SQL Server, or in File system, or in SSIS Package store using SQL Server ...
|
|
|
|
Total Hits: 14 | Today: 0
|
Author: Siddharth Mehta
|
Rating:
|
|

Address information is one of the most common attributes of data stored in a business data repository. Examples of such data can be addresses of employees, store locations of retail chains, sales of a product etc. You may wonder about the last example and how sales of a product can be linked with an address. In most of the retail chains, customers are provided with a loyalty card, on which they collect points for each product purchased. This card contains the address of the customer and so geo...
|
|
|
|
|
|