Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Exploring SSIS - Understanding the basics

Dec 4 2012 12:00AM by Madhivanan   

SQL Server Integration Services (SSIS) is one of the tools that can be effectively used to transfer data to various destinations. In versions prior to 2005, we had Import/Export wizard which was part of Database Engine and a package would be created based on this. But from 2005 onwards SSIS comes as a seperate package along with SQL Server. This is built on top of Visual Studio (.NET) and known as Business Intelligence Development Studio (BIDS) that allows more powerful way of transforming data. Although this is primarily used for ETL(Extract, Transform and Load) purpose, a lot more can be done.

SSIS has following sections

1 Control Flow
2 Data Flow
3 Event Handler
4 Package Explorer

We will breifly see what these do

1 Control Flow
This controls the entire flow of SSIS pacakge. We can make use of various Control Flow items available like Execute SQL task, File System task, FTP task, Send mail task, etc. The Execute SQL Task can be effectively used to execute Stored Procedures, delete/truncate tables, or perform other DML statements. We can have many tasks in this Flow and order them so that the tasks are executed in the order they are specified. The ordering can be done by using the Precedence Constraint ie when you see Green Arrow for a task, you can drag it to connect to the next task that should be executed

2 Data flow
This is primary used to connect to various sources (Database Servers, Flat files,etc) and load them to different destinations. The items of this task are categorised into three (Sources, Transformation and Destinations).

3 Event Handler
This responses to the events raised by the executable items like data flow task, for each loop, etc. The event can be executed to perform various tasks like sending email notification if one of the tasks is failed, clearing staging tables, etc

4 Package Explorer
This shows the entire list of package items like variables, connection managers,event handlers, executables, etc

Keep reading this series of posts for more interesting informations about SSIS.

Tags: 


Madhivanan
3 · 40% · 12912
7
 
0
Lifesaver
 
 
0
Learned
 
0
Incorrect



Submit

5  Comments  

  • I look fwd to next posts and interesting tips on SSIS! Thanks for this introduction - it helped me refresh my concepts.

    commented on Dec 11 2012 6:49PM
    Paras Doshi
    17 · 10% · 3265
  • Hi Madhivanan ,

    its interesting topic , implementation is more useful on this i have used sql server replication for data transmission .

    commented on Dec 12 2012 4:51AM
    sumit.kanugo
    2033 · 0% · 8
  • Thanks Paras Doshi and Sumit.kanugo for your feedback

    commented on Dec 13 2012 12:09AM
    Madhivanan
    3 · 40% · 12912
  • Hi Madhivanan,

    If the package is in debugging mode then Progress tab will appear along with your control flow, data flow, event handler and package explorer

    Thanks

    commented on Jan 18 2013 3:42AM
    Bala Krishna
    83 · 2% · 676
  • Bala Krishna, Yes thats a good point to note. Thanks

    commented on Jan 18 2013 4:18AM
    Madhivanan
    3 · 40% · 12912

Your Comment


Sign Up or Login to post a comment.

"Exploring SSIS - Understanding the basics" rated 5 out of 5 by 7 readers
Exploring SSIS - Understanding the basics , 5.0 out of 5 based on 7 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]