x
login about faq Site discussion (meta-askssc)

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 13 18 19

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

more ▼

answered Mar 07 '11 at 07:55 PM

KenJ gravatar image

KenJ
12.4k 2 10

(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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x13

asked: Mar 07 '11 at 07:42 PM

Seen: 1247 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.