what is DTS/SSIS in SQLSERVER?

Question

Hi

what is DTS/SSIS in sqlserver.Can i need to separately Insatll these services.

what is use of this DTS/SSIS in sqlserver.How to configure these DTS/SSIS ???

Help me in this regard plzzzz

Thanks in advance.

Answer 1

SSIS = SQL Server Integration Services. From Microsoft:

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations. Integration Services includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

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

It's actually really cool stuff. Oracle has a pretty cool business intelligence editor for their dbms as well.

Answer 2

Check out this link : SSIS (SQL Server Integration Services) VS DTS (Data Transformation Services) : A basic overview

Answer 3

On SSIS, take a look at this related question. I have posted useful links for SSIS on this question: http://stackoverflow.com/questions/454802/what-is-ssis-package-what-does-it-do/454955#454955