|
|
| Book details / order |
| SQL SERVER INTEGRATION SERVICES USING VISUAL STUDI |
Sql server integration services with the acronym ssis is a comprehensive etl tool that made its debut with sql server 2005. it is a tool tightly integrated with the visual studio 2005 having all the functionalities that its forerunner dts (data transformation services) had in sql server 2000. this does not mean that it is just an improvement over dts but a product which is totally different with a vastly improved interface; an extensible architecture; an enlarged tool set; ease of integration with other sql server tools such as analysis services; capable of supporting connectivity with third party databases and bringing into a central location many database management tasks.
beginners guide to sql server integration services using visual studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced etl [extraction, transformation, and loading]. the book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. this guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. a majority of ssis tasks are covered in this book and they are described fully in the summary of table contents section. you start building packages right from chapter 2 and continue on to chapter 20 gathering and building upon your knowledge in each step.
what you will learn from this book
* environment set up for visual studio 2005 with respect to ssis
* multiple tasking
* connecting to microsoft access, text files, excel spread sheets
* linking data source and data destination to a task
* transforming data from a source going to a destination
* using the scripting support that the ide provides
* learning about tasks such as web service and xml, which are new in sql server 2005
* understanding how to use and handle events
who this book is written for
this book is written for beginners in the developer track who are looking to get an exposure to sql server integration services; dba's who are testing water with the visual studio ide but without a wide programming experience; sql 2000 data transformation services users who are trying to move into sql server 2005 integration services; microsoft programming professionals in small businesses who wear multiple hats (jack of all) - developer, programmer, and dba with a little bit of experience in each of these.
Author : Jayaram krishnaswamy
Publication : Packt publication
Isbn : 9788184044560
Store book number : 102
NRS 600.00
|
 |
|
|
|
|
|
|
|
| |
|
|
