Post reply

NEW TO SSIS

  • December 28, 2009 at 11:27 pm

    #141388

    hi

    i am new to ssis..can any one tell what is ssis and whats its purpose and use of it..what is the difference between the dts and ssis...

  • December 29, 2009 at 3:09 am

    #1096952

    Dude, this is not a question for a forum... In a nutshell, SSIS is the new DTS, but for further reading, go to BOL: http://msdn.microsoft.com/en-us/library/ms141026.aspx%5B/url%5D

  • January 11, 2010 at 1:54 pm

    #1102040

    SSIS

  • January 11, 2010 at 1:55 pm

    #1102041

    SSIS or Integration Services is Microsoft’s ETL tool. Essentially, it is a tool to move and manipulate data between various sources. You might move data from an Oracle server, to a SQL Server, and then manipulate the data in SQL Server to produce an Excel spreadsheet which is FTP’ed to another company’s FTP server, for example. It is an extremely flexible tool with the goal of making it possible to move data between any set of data sources in the enterprise. T-SQL as well as Visual Basic Script code can be utilized in an SSIS package to manipulate the data an almost infinite number of ways in order to make any data transfer possible including those involving complex business logic.

    SSIS packages integrate directly into SQL Server and can be managed within SQL Server and run as scheduled jobs at regular intervals to handle regular movement of bulk data, and other tasks, within the company.

    SSIS in SQL 2005 is essentially what DTS was in SQL 2000. However, with SSIS Microsoft completely rethought and redesigned DTS from the ground up to become an entirely new product thousands of times more powerful known as SQL Server Integration Services.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply