Search Results: Catalog

• 
  SSIS 2012: Programmatically Create Catalog

  This article uses a Script Task in SQL Server Data Tools to demonstrate creating a catalog and catalog folder.

  Author:  mafiswana     Date: 7/18/2012     Section: Article

  tags : C#, C# programming language, Catalog, CatalogFolder, IntegrationServices, Managed Object Model, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, script task, SMO, SMO Server, SQL Server 2012, SQL Server Integration Services, SSIS, SSIS 2012, Visual Studio 2010
• 
  Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

  SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#.

  Author:  mafiswana     Date: 8/14/2012     Section: Article

  tags : CatalogFolder, Create SSIS Package, Managed Object Model, Microsoft Visual C# 2010, Microsoft.SqlServer.Dts.Runtime, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, SSDT, SSIS 2012, SSIS Catalog, Visual Studio 2010
• 
  Dump MDX OLAP Query output to a relational table from SSMS

  I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.

  Author:  artuladhar     Date: 5/16/2012     Section: Blog

  tags : dump, file, MDX data, OLAP, output, query, Table
• 
  Deployment using Integration Services Catalog in SQL 2012

  When SQL 2012 came out earlier this year, one of the biggest changes to its functionality was how the user deploys his or her Integration Services packages. You still have the option to, from Management Studio, attach it to your Integration Service instan

  Author:  RCharCox     Date: 5/22/2012     Section: Blog

  tags : 2012, Deployment Utility
• 
  Report catalog tip

  SSRS 2008 r2 Using variables in the report to create a report catalog with extra user defined attributes as follows: From report designer or report builder 3.0 right click in the area outside the report on the design surface, select report properties and

  Author:  syale     Date: 7/30/2011     Section: Blog

  tags : Attributes, Catalog
• 
  An Overview of SSIS Projects in SQL Server 2012

  One of the new and exciting features of SSIS in SQL Server 2012 is the SSIS Project and project deployment model that is now available. The new project deployment model includes a new option for deployment as well as a bunch of new features such as shared

  Author:  cprice1979     Date: 1/22/2012     Section: Blog

  tags : sqlserver 2012
• 
  Creating the SSIS 2012 catalog

  In SSIS in SQL Server 2012, it is no longer necessary (for new installations/packages) to install a separate integration services instance onto the server. It can all be managed from within the database engine. In order to be able to utilize this feature,

  Author:  ChrisSchmidt     Date: 12/17/2012     Section: Blog

  tags : Catalog, SSIS 2012
• 
  SSAS Compare, a cool tool for Microsoft Business Intelligence professionals.

  Hello BIDN Family, It’s been long time gap and I was really missing my blogging time part. Through this blog I would just want to share the new tool developed by the Red –Gate called SSAS Compare . which I think , SSAS Compare is one of the co

  Author:  Anil     Date: 6/12/2012     Section: Blog

  tags : SSAS Compare
• 
  Can we have some tool or some methods in order to generate some possible combination of MDx automatically by just pointing the SSAS cube?

  Hello , After some research I finally got the solution for this particular task. Please have a look in this blog post of mine http://www.bidn.com/blogs/Anil/ssas/2185/generate-possible-combination-of-mdx-automatically-by-just-pointing-the-ssas-cube-catalo

  Author:  Anil     Date: 9/14/2011     Section: Forum
• 
  Can we have some tool or some methods in order to generate some possible combination of MDx automatically by just pointing the SSAS cube?

  Hello , After some research I finally got the solution for this particular task. Please have a look in this blog post of mine http://www.bidn.com/blogs/Anil/ssas/2185/generate-possible-combination-of-mdx-automatically-by-just-pointing-the-ssas-cube-catalo

  Author:  Anil     Date: 9/14/2011     Section: Forum
• 
  SSIS 2012 Catalog

  In 2005 and 2008, SSIS required a lot of manual configurations regarding deployment, configurations, environments, etc. It took a lot of time just to set up the environment for proper performance. Microsoft came up with a term for this, and called it the

  Author:  ChrisSchmidt     Date: 11/6/2012     Section: Blog

  tags : 2012, Catalog, Denali, SQL Server Integration Services, ssis
• 
  Report Catalog tip

  SSRS 2008 r2 I am using variables in the report to create a report catalog with extra user defined attributes as follows: From report designer or report builder 3.0 right click in the area outside the report on the design surface, select report properties

  Author:  syale     Date: 7/29/2011     Section: Forum

  tags : attributes, Report Catalog, variables
• 
  SSISDB Reporting

  Thanks again to everyone who attended my session today on SSIS DB Reporting: Now What? At the end of the presentation there were several questions that came up that we didn’t have time to answer. Below is the Q&A from the session, I hope this an

  Author:  ChrisSchmidt     Date: 1/16/2013     Section: Blog

  tags : data flow performance, data taps, integration services catalog, SSIS 2012, ssis performance
• 
  SSRS: Information about reports ran

  Some times is very useful to gather information about report execution, for example: How often a report is requested Report duration time (slowest reports) User that ran more reports What formats are used the most This information can be achieved from Exe

  Author:  marcoadf     Date: 4/6/2010     Section: Blog

  tags : ExecutionLog, reports ran, reportserver, slowest reports, ssrs
• 
  Cross Reference for ReportServer.dbo.Catalog.Type

  The chart below will help you if you ever need to work in the ReportServer database and can’t figure out what Type is in the Catalog table. Believe it or not but there’s not much documentation on this just a few websites asking this same question. TomLann

  Author:  ChrisAlbrektson     Date: 9/10/2010     Section: Blog

  tags : Catalog.Type, ReportServer
• 
  Pull security info only from Cube backup file

  Hi everybody, I have a couple of SSAS db backups and i need to check the security roles of each of them. Is there any way i can pull just the security info from the (.abf) cube backup files without the whole restore of the cube catalogue. I know this soun

  Author:  asimshrestha     Date: 1/12/2012     Section: Forum

  tags : restore, roles, Security, ssas backup, xmla
• 
  How to temporarily stop SSRS subscriptions

  I sometimes will be needing to temporarily stop scheduled subscriptions due to a review process of the reports. Am I correct in thinking that I will be able to use the following to safely stop the subscription temporarily without reporting server throwing

  Author:  lculley2012     Date: 1/12/2012     Section: Forum
• 
  Can we have some tool or some methods in order to generate some possible combination of MDx automatically by just pointing the SSAS cube?

  Hello all , I just want to ask that can we have some tool or some methods in order to generate some Possible combination of MDx by just pointing the SSAS cube. Let’s say we have some 10 Dimensions ,2 Measure Groups and 3 Cube within a single Catalog

  Author:  Anil     Date: 9/9/2011     Section: Forum
• 
  SSRS – Creating a Reporting Services Web Farm

  Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of the two. In this post I’ll review the process of scaling-out Reporting Services so server resource constraints

  Author:  DevinKnight     Date: 2/20/2012     Section: Blog

  tags : configuration
• 
  Generate possible combination of MDx automatically by just pointing the SSAS cube Catalog.

  Hello all, After such a long time , I would like to post some another blog which might be helpful to the one who works in BI mainly in SSAS/MDx. I simply need to generate some possible combination of MDx automatically by just pointing the SSAS cube Catalo

  Author:  Anil     Date: 9/13/2011     Section: Blog
• 
  Steps to schedule and automate backups of all the SSAS catalogs/ databases within a server instance.

  With the course of time, you might need to backup all the SSAS databases within a server instance automatically and schedule to backup these database monthly wise or according to your specific time set. May be there are a lot of alternative methods to per

  Author:  Anil     Date: 3/11/2011     Section: Blog

  tags : Job Agent, SSIS, SSMS, SSAS
• 
  Fun with MDX: Part 2–Product Contribution Ratio

  In this installment of Fun with MDX we are going to put together a solution that will allow us to view the contribution ratio of internet sales for each level in the Adventure Works product hierarchy. This solution will look at two contexts for this ratio

  Author:  cprice1979     Date: 1/3/2012     Section: Blog

  tags : Tips and tricks
• 
  Le sac lancel peut être découvert dans des styles variés avec quelques échos

  À propos de laquelle elle a déclaré. Qui plus est, cela permettra d'accorder l'ensemble qualifiée semble. Il y avait de repenser notre stratégie sur lancel sac en faisant un concept de franchisage international normalis&

  Author:  boutra     Date: 11/9/2012     Section: Forum

  tags : lancel bb, lancel sac, vente privee lancel
• 
  Ces sacs Lancel viennent également avec aucune limite pour vous

  sac a main lancel a également suggéré que les parents devraient être une utilisation rationnelle. Le maquillage et la coiffure, c’est un excellent exemple du style authentique qui caractérise les femmes à des

  Author:  boutra     Date: 11/9/2012     Section: Forum

  tags : sac a main lancel, sac adjani lancel, vente privée sac
• 
  connect SSAS to a DB2 data source - "The parameter is incorrect"

  Hello, I am new to the SSAS world (SQL Server 2008 R2). I have completed some basic tutorials and now trying to work with my own data at work for my first cube development. Background... I am using DB2 as my dimensional data source. I have the appropriatt

  Author:  JamieG     Date: 1/23/2013     Section: Forum

  tags : connection issues, connection manager, db2