What is SSISDB in Sql Server 2011(Denali)

In Sql Denali, so far the SSIS is concern we have something as SSISDB.It is a rather new stuff. I searched in the net to get good info on the same but no proper luck. could anyone please explain me in detail as what it is. Any link or reference will also do.

Thanks

asked Mar 07 '11 at 07:42 PM in Default

learner
302 ● 13 ● 18 ● 19

(comments are locked)

1 answer:

It's a new database for managing all aspects of Integration Services...

In Microsoft SQL Server Code-Named “Denali” CTP1, Integration Services (SSIS) introduces the SSISDB catalog, which is the central storage and administration point for Integration Services projects, packages, parameters, and environments. The catalog also stores detailed operational information. You can use SQL Server Management Studio and Transact-SQL to closely monitor the progress of operations, detailed messages related to operations, and the actual parameter values that are used with an instance of package execution

The article goes on to give an overview of managing SSIS via T-SQL and through SSMS.

It also links to an SSIS Catalog Overview and an Architecture and API document

answered Mar 07 '11 at 07:55 PM