Let me start with an era when we use to import or export data with DTS import/ Export tool or Microsoft Data transoformation services tool. DTS is nothing but an ETL tool (Extract, Transforms and Load), Which allows data base administrator to createset of stepsthat describe that how data to be transformed.
These “packages,” as they’re called, can then be executed via a number of different programming languages or directly within SQL Server itself.
The idea was and still is a good one, but ultimately too limited — it remained a glorified if convenient version of the bulk-copy system used in earlier versions of SQL Server.
With SQL Server 2005, Microsoft decided to turn DTS into a whole new kind of ETL tool — SQL Server Integration Services (SSIS). Moving data from one database to another or exporting a database in another format are only the most basic things you can do with SSIS.
Why should i use SSIS or what are the things that will be helpful while using SSIS ? –> Good question
Let me try –> in next post …