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.

more ▼

asked Mar 07, 2011 at 07:42 PM in Default

learner gravatar image

302 17 18 20

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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][3] document

[3]: http://social.technet.microsoft.com/wiki/contents/articles/catalog-architecture-and-api-in-sql-server-denali-ctp1-ssis.aspx
more ▼

answered Mar 07, 2011 at 07:55 PM

KenJ gravatar image

20.4k 1 4 12

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 07, 2011 at 07:42 PM

Seen: 1903 times

Last Updated: Mar 07, 2011 at 07:42 PM