This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.In SQL 7.0, Microsoft added the BULK INSERT statement to Transact-SQL.This new statement allowed the DBA to use SQL to load data into SQL Server instead of having to use the command line and BCP. Although Bulk Insert provides many anbsp;...
|Title||:||SQL Server DTS|
|Author||:||Steve Hughes, Jim Samuelson, S. Miller, M. Santos|
|Publisher||:||Sams Publishing - 2002|