SSIS Information

asked 2021-04-13T06:08:34.653+00:00
Waris Shah 1 Reputation point

I am new in SQL Server, using developer edition. Actually I want to use SSIS for ETL Process. I want to know that SSIS works with only Integration Services or it also works with database engine, analytics service, reporting services of sql server. Mean my target database can be database engine, analytics service, reporting services or not?

Another is that can we use SSIS for other database such as Oracle, Teardata and limitations of Developer edition in sense of data storage quantity ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2021-04-13T06:46:23.773+00:00
    Olaf Helper 25,476 Reputation points

    Another is that can we use SSIS for other database such as Oracle, Teardata

    SSIS can access any data sources, where you have a working OleDB, ODBC or .NET data provider for; see Integration Services (SSIS) Connections

    limitations of Developer edition in sense of data storage quantity ?

    Developer Edition has the same unlimited feature set as the Enterprise Edition, see Integration Services features supported by the editions of SQL Server


  2. answered 2021-04-13T08:58:40.843+00:00
    Monalv-MSFT 5,686 Reputation points

    Hi @Waris Shah ,

    1.SQL Server Integration Services * is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.*

    2.The SSISDB catalog * is the central point for working with Integration Services (SSIS) projects that we've deployed to the Integration Services server.* We access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer.

    3.SQL Server Data Tools (SSDT) * is a modern development tool for building SQL Server relational databases, databases in Azure SQL, * Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, we can design and deploy any SQL Server content type with the same ease as we would develop an application in Visual Studio.

    4.Analysis Services * is an analytical data engine (Vertipaq) used in decision support and business analytics.*
    SQL Server Reporting Services (SSRS) * provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.*

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.