Data Transformation Services (DTS) Interview Questions
| Data Transformation Services (DTS) Interview Questions |
|
|
DTS is available in SQL 2000. It stands for Data Transformation Services. It is (or was) a use fuel tool for importing data from one source to another. Like from an Access, SQL, Oracle, PHP DB, or a flat file or spreadsheet into a SQL Database - or whatever. Once a DTS package is created, you could then create a job that will automatically run the package on a set schedule - for example you may want to import new records from one table to another table every night. But DTS isn't in SQL 2005 - but you can still use old DTS packages with 2005. The new technology is SQL Server Integration Services (SSIS).
|
|
|
|
Microsoft SQL Server 2005 Integration Services (SSIS) makes it easy to create robust and complex solutions for extracting, transforming, and loading data (ETL). The Integration Services tools let you design, create, deploy, and manage packages that address everyday business requirements.
|
|
|
|
Pls help me out to get the PDF of SQL DTS
|
|