Home > IT Answers > SQL Server > SQL Server - SSIS
9049726550
5 pts.
Q:
SQL Server - SSIS
SSIS, SQL Server 2005
what is SSIs in Sql Server?

Software/Hardware used:
Sql Server 2005
ASKED: Feb 4 2010  6:03 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Msi77
940 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
SQL Server Integration Services.
Import/export data from/in different data sources.
Last Answered: Feb 4 2010  5:09 PM GMT by Msi77   940 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

RickMartinez   190 pts.  |   Feb 4 2010  6:58PM GMT

SQL SERVER INTEGRATION SERVICES.

SSIS is an ETL (Extraction, Transformation, and Loading) tool tightly integrated with Visual Studio. You can select data from one or more sources and standardize, join, merge, cleanse, calculate, and perform just about any other functiion and operation for your data.
One common use for SSIS is to move data from one data source to another.

If you are planning a data warehouse SSIS is what you should use.