(Information is Beautiful)

Learning SSIS

We’re very fortunate that Microsoft provides very rich tutorials and documentation, so it should be easy to follow some self-guided training. I have provided a list of links for you below, to start becoming familiar with the tool. I would also suggest picking up a book.

SSIS (SQL Server Integration Services)

 

Example Training/Curricula

http://www.kimballgroup.com/microsoft-dw-bi-in-depth/

http://www.microsoft.com/learning/en/us/course.aspx?ID=10777A

http://www.microsoft.com/learning/en/us/course.aspx?ID=6235A

 

Books

http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/booksmdwt/

http://www.amazon.com/Knights-24-Hour-Trainer-Microsoft-Integration/dp/0470496924/ref=sr_1_1

http://www.amazon.com/Professional-Microsoft-Server-Integration-Services/dp/111810112X/ref=sr_1_6

 

Reference

http://technet.microsoft.com/en-US/sqlserver/cc511477.aspx

http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx

http://msdn.microsoft.com/en-us/library/ms141026.aspx

http://msdn.microsoft.com/en-us/library/bb522537.aspx

http://social.technet.microsoft.com/wiki/contents/articles/6752.ssis-list-of-transformations.aspx

 

Development

http://msdn.microsoft.com/en-us/data/tools.aspx

http://technet.microsoft.com/en-us/library/ms124623(v=sql.105).aspx

http://www.codeplex.com/site/search?query=integration%20services&ac=1

 

Social

http://blogs.msdn.com/b/mattm/

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads

http://stackoverflow.com/questions/tagged/ssis

 

Lab

https://cmg.vlabcenter.com/default.aspx?moduleid=cbc7fcb5-e91b-4899-af86-1c4cb36f2a1d

 

Tutorials

http://msdn.microsoft.com/en-us/library/bb522500(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx

 

 

Learnings

http://channel9.msdn.com/shows/toolshed/ToolShed-Tooltip-20-SSIS-Data-Profiling-saves-your-eyeballs/

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI310

http://channel9.msdn.com/posts/SSIS-troubleshooting-Demo

http://channel9.msdn.com/Events/TechEd/Europe/2010/BIN302

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI322

[http://channel9.msdn.com/search?term=ssis for more…]

 

Videos

http://www.youtube.com/watch?v=dzfZJlN4nzI

http://www.youtube.com/watch?v=I_Ae3suaL-U

http://www.youtube.com/playlist?list=PL6E7A1AB2E25073A9

http://www.youtube.com/playlist?list=PL07DD9B6AB8DEABFF

http://www.youtube.com/playlist?list=PL33BDF0753861ADD4

http://www.youtube.com/watch?v=oTJjGH7eyns&playnext=1&list=PL2900t3sPCl2XP6qMg94IjtQYYlgjIe3x&feature=results_main

http://www.youtube.com/watch?v=hJjH42P427o&playnext=1&list=PL53A0BBD46BDBB881&feature=results_main

[http://www.youtube.com/results?search_query=sql+server+integration+services for more…]

[http://www.youtube.com/results?search_query=ssis for more…]

Advertisements

One response

  1. Reblogged this on From the Dark Water and commented:
    Excellent resources.

    March 8, 2013 at 19:25

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s