x

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
more ▼

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

learner gravatar image

learner
302 16 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 '11 at 07:55 PM

KenJ gravatar image

KenJ
19.1k 1 3 11

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x13

asked: Mar 07 '11 at 07:42 PM

Seen: 1697 times

Last Updated: Mar 07 '11 at 07:42 PM