Thursday, March 31, 2011

The SSIS Data Pump - Step 2 of the Stairway to Integration Services

Guys,

As we all know that SQL Server Integration Services is one of the most popular subsystems in SQL Server. In allows us to Extract, Transform, and Load (ETL) data between a variety of data sources and programmatically change data in any manner you can think of and script in C#.

In our previous Part 1 – BIDS we learned our way around Business Intelligence Development Studio and we are now itching to build an SSIS package that moves real data!

This article explains:
  • The relationship between Connection Managers and adapters (OLE DB Source and OLE DB Destination)
  • Role and some features of Data Flow Paths that connect Data Flow Task components to each and represent the "data flow pipeline"
  • Design-time validation and how to view Errors and Warnings.
  • Some cool time-saving features of the Adapter Editors - we will fall in love with these New buttons!
  • Formatting components on the Data Flow canvas so they're aligned.
  • Take a peek under the hood of the Data Flow Task, viewing the Data Flow Path metadata.
  • How this metadata can be used by the OLE DB Destination to build a CREATE TABLE statement.

 
Happy Learning
 
Sudhir

What is SSIS? Step 1 of the Stairway to Integration Services

Guys,


As we know that SQL Server Integration Services is one of the most popular subsystems in SQL Server. In allows us to Extract, Transform, and Load (ETL) data between a variety of data sources and programmatically change data in any manner you can think of and script in C#.

We can use SSIS to:
  • Perform ETL (Extract, Transform, and Load) operations
  • Transfer data
  • Copy database objects
  • Perform FTP operations
  • Work with files
This article from SQLServerCentral provides an introduction to SQL Server Integration Services, and an overview of its architecture.

To read this article, click here

Happy learning

Sudhir


 

  


 

 

 

Monday, March 21, 2011

Resources for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

Guys,

Everyone faces issues when migrating data from various sources like Oracle, MySQL, Sybase or Access to SQL Server.

We might have come across issues like:
  • How to correct schema issues?
  • Data type conversion cases
  • Should comments be saved or no?
and many more.

To get an answer to these questions, refer to Microsoft SQL Server Migration Assistant (SSMA) Team's Blog

There are many examples, which are very helpful.

Happy Learning.

Sudhir

Thursday, March 10, 2011

Stairway to SQL Server Agent: Step 1: Setup and Overview

Hi,

We all come across a situation where we need to schedule something & run the process in background automatically in database itself.

The tool that we can use to achieve this task is SQL SERVER AGENT.

SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.

In this article Richard explains following things:
  • SQL Server Agent Setup and Overview
  • Getting SQL Server Agent Running
  • Setting the Agent to Auto-start with SQL Server
  • Creating your first Job


Click here to read full article.
 
Happy Learning
 
Sudhir

 

 

 

Thursday, March 3, 2011

Stairway to MDX - STEP 1: Getting Started with MDX

Guys,

If you want to start learning MDX then here is a wonderful article from Bill Pearson on Stairway to MDX - PART I.

Click here to access the article.

Bill has explained following topics on MDX in this article:

  • Installing Analysis Services 2008R2 and Samples
  • Accessing an MDX Editor
  • Creating an MDX query
    • Introduction
    • Syntax
  • Trying things out: A few initial queries
  • Procedure: Satisfy Business Requirements with MDX

Hope its useful for everyone.
 
Happy Learning
 
Sudhir