Solved

Beginners books on SSIS

Posted on 2013-11-25
2
368 Views
Last Modified: 2016-02-11
I would like to learn and do some practical packages. Please do suggest appropriate books for me. Thanks.

Please note that I'm using VS 2010 and SQL Server 2008 R2.
0
Comment
Question by:Easwaran Paramasivam
2 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
ID: 39676670
Well, there is quite a few resources around ranging from MS press, all the way through to youtube.

Some good starting places are : http://download.microsoft.com/download/a/c/d/acd8e043-d69b-4f09-bc9e-4168b65aaa71/ssis2008Intro.doc and a tutorial : http://technet.microsoft.com/en-us/library/ms169917.aspx (look at topics on the LHS of page - and the external videos link down the very bottom might be interesting - have not looked though)

And the developers guide : http://technet.microsoft.com/en-us/library/ms136025(v=sql.100).aspx 
and notice the link down the bottom to Developer InfoCenter :http://technet.microsoft.com/en-us/library/ms137709(v=sql.100).aspx

The above gives you all the corresponding links to samples, the manual et al...

And codeproject also has a multipart series : http://www.codeproject.com/Articles/155829/SQL-Server-Integration-Services-SSIS-Part-1-Basics albeit starting with 2005 but easy to read and easy to follow...

Then there is Jason's 31 days of SSIS : http://www.jasonstrate.com/2011/01/31-days-of-ssis-the-introduction/  which is more "sample" than an intro course as such.

I would be inclined to start from the top down, and then can go find more "practical" or advanced subject matter.

Have fun ! SSIS is extraordinarily powerful and sometimes quite frustrating - all the best ingredients for a developer :)
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 39676696
Thanks.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now