SQL Server – SSIS

5 pts.
Tags:
SQL Server 2005
SSIS
what is SSIs in Sql Server?

Software/Hardware used:
Sql Server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Server Integration Services.
Import/export data from/in different data sources.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rick Martinez
    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.
    585 pointsBadges:
    report
  • Colin Smith
    SSIS replaced the ETL tool called DTS that you may have been familiar with in SQL Server 2000.
    945 pointsBadges:
    report
  • edwinjhoffer
    SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.  While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created. 
    3,000 pointsBadges:
    report
  • danieljones
    SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data
    105 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following