asked
Study Material for SQL Data Transformation services
Hi All DTS Champs, I am a beginner in data transformation services. Can anybody suggest me any good material like Ebook on DTS which not only explains all the topics but also has good hands on material also. Any lab manual or dummy project will also be great. Thanks Nikhil
You want to study the DTS (Data Transformation Services) for SQL Server 2000? Or rather SSIS (SQL Server Integration Services) - SQL Server 2005+? [Marcin Policht on Database Journal][1] site has a lot of interesting articles and tutorials related to DTS and also SSIS. In case of SSIS you can find several interesting sites and blogs: [SQL Skills - SQL Server Integration Services - SSIS][2] [SSIS Team Blog][3] [SQL Server Integration Services Samples][4] [SSIS Junkie][5] [SSIS Talk][6] There are also a lot of interesting books. You can take a look on Amazon for example. For Overall Microsoft BI knowledge you can start for example with [Learn Microsoft BI][7] site, which has a lot of interesting video tutorials. [1]:
http://www.databasejournal.com/article.php/1503191 [2]:
http://www.sqlis.com/sqlis/ [3]:
http://blogs.msdn.com/b/mattm/ [4]:
http://msftisprodsamples.codeplex.com/ [5]:
http://sqlblog.com/blogs/jamie_thomson/ [6]:
http://www.ssistalk.com/ [7]:
http://www.learnmicrosoftbi.com/
