Search Results: scripting

• 
  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
• 
  Scripting Indexes

  I was recently reading a blog posting on BIDN , Scripting Indexes with Filters and schemas . In the posting the author explained the challenges of trying to script only indexes using SQL Server Management Studio (SSMS). Moreover, the author adds that ther

  Author:  PatrickLeBlanc     Date: 1/15/2010     Section: Blog

  tags : Indexes, Scripting, SQL Server
• 
  Script Indexes With Your Table

  Scripting tables inside of SQL Server Management Studio is a very simple task. Just right click and select script table. The problem is that, but default, the indexes on a table are not part of the script. Rather than scripting the indexes separately from

  Author:  BradSchacht     Date: 9/3/2010     Section: Blog

  tags : Scripting, SSMS
• 
  MDX Scope with an If Then Exception or Filter

  The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here . The issue I am going to cover will be using the scope statement when you only

  Author:  MikeDavis     Date: 8/5/2010     Section: Blog

  tags : Exception, Filter, If Then, Scope, MDX
• 
  Adding expression to Derived Column Transformation

  Try setting this up ( I'm assuming SQL 2005 - with VB.Net being your scripting language ). 1) 3 string variables: PathToExcel maybe set it to C:\Temp\ -- copy 3 or 4 xls files to this folder. ExcelFileMark This might be *.xls for office 2003 or *.xlsx for

  Author:  KeithHyer     Date: 4/12/2011     Section: Forum

  tags : directory, file list, file system, script task, latest file
• 
  Alter table

  If you script out your table, you should see your extended properties below the table creation portion. You should be fine by scripting table, dropping and recreating with the new column. I just tested it using the below script below. Added table with two

  Author:  briankmcdonald     Date: 7/19/2011     Section: Forum

  tags : Brian K McDonald, extended properties, sqlbigeek, TSQL
• 
  MDX Scripting with SCOPE Statement

  In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.

  Author:  DustinRyan     Date: 3/15/2010     Section: Article

  tags : MDX Scripting, SCOPE statement, MDX
• 
  T-SQL to return disk space in a table

  I often need to know how much free space is available on a drive before and after a cube has been updated. The code below returns a table with Total and Free space per drive. It relies on OLE Automation procedures being configured correctly. SET NOCOUNT O

  Author:  Maxui     Date: 5/23/2012     Section: Blog

  tags : Disk space, Ole Automation Procedures, T-SQL, useful
• 
  SQL Saturday Tampa Follow Up

  This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62. It was a great event organized by Pam Shaw. My talk was right after lunch and the lunch sessions were running a little bit late, so when I arrived,

  Author:  briankmcdonald     Date: 1/21/2011     Section: Blog

  tags : Brian K. McDonald, Reporting Services 2008, Tampa, SQL Saturday
• 
  How to migrate Scripting.Filesystem objects used inside ActiveX script to SSIS equivalent task/code?

  Generally developers use Scripting.FileSystem object in ActiveX script task to perform various file system related tasks (e.g. Copy file, Delete file etc.). In SSIS you can perform many file system related common tasks using File System task . You should

  Author:  BrianKnight     Date: 11/7/2009     Section: Blog
• 
  MVPs on the SQL Lunch

  On January 19 th and February 25 th the SQL Lunch will have two well known authors, speakers and MVPs presenting at the SQL Lunch . First on January 19 th , Brian Knight will be presenting Scripting in SSIS and if that is not enough Brad McGehee will be p

  Author:  PatrickLeBlanc     Date: 1/14/2010     Section: Blog

  tags : SQL Server, SSIS, SQL Lunch
• 
  MDX - Color Formatting on All Measures at Once

  In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services measures you create. Recently I found a way to apply this same color formatting to all your measures. Why would you want this? Well let's say you

  Author:  DevinKnight     Date: 11/4/2010     Section: Blog

  tags : MDX, SSAS
• 
  Number Formatting in MDX Scope Statement

  This morning, I found Dustin Ryan's article on the use of MDX scope statements, http://www.bidn.com/articles/mdx-and-dmx/94/mdx-scripting-with-scope-statement and was able to build further on his solution. Background: Our organization is building out a da

  Author:  schilders     Date: 8/12/2010     Section: Blog
• 
  SQL Saturday 85 Orlando

  I am very excited to announce that the Schedule is now live for SQL Saturday 85 in Orlando, remember to save the date for Saturday September 24th! There will be a lot of information to come. There is a Full Day Pre-Con Training also. I will be seaking on

  Author:  MikeDavis     Date: 7/26/2011     Section: Blog

  tags : Orlando, SQL Saturday
• 
  Error when browsing cube in BIDS or SSMS: “An error 0xE0040200 occurred. No further information was provided.”

  While working on an SSAS project today, I was scripting out some MDX calculations in the cube (year to date, month to date, previous year’s month to date, and previous year to date). I wrote the calculations and they looked perfect, but when I tried to br

  Author:  DustinRyan     Date: 4/4/2011     Section: Blog

  tags : error, SSAS
• 
  Conditional Calculation Script Based on Roll Up

  Thanks for your help, Luke. I also did a little write up on a simple SCOPE statement: http://www.bidn.com/articles/mdx-and-dmx/94/mdx-scripting-with-scope-statement .

  Author:  DustinRyan     Date: 3/16/2010     Section: Forum
• 
  Conditional Calculation Script Based on Roll Up

  Glad you got it working. Those are some pretty complex overwrites. You code looks fine to me. If interested I blogged on a simple use of SCOPE here. http://www.bidn.com/blogs/CurrentMember/bidn-blog/318/mdx-scripting-hiding-lower-levels-of-higher-grained-

  Author:  CurrentMember     Date: 3/16/2010     Section: Forum
• 
  Posting to a Web Service from SSIS?

  The only way that I know this can be done would be by using custom Scripting. When you use the Scripting Transform in the Data Flow you can set it up as a Destination and setup the custom code in VB or C# to initiate the webservice proxy and send the reco

  Author:  SteveWake     Date: 2/16/2013     Section: Forum
• 
  MDX Query for a calculated measure with two/more aggregate function

  This sounds like something you'll have to do with a Scope statement if you want to aggregate the measures differently based on how its sliced. Check this article out about it and give it a shot.

  Author:  DustinRyan     Date: 5/10/2011     Section: Forum
• 
  Calculation in Cube depending upon user selection

  You want to use the SCOPE statement in a Script Command calculation. Check out this post to get started but there are several others on the site that show SCOPE. http://www.bidn.com/articles/mdx-and-dmx/94/mdx-scripting-with-scope-statement

  Author:  DevinKnight     Date: 1/4/2012     Section: Forum
• 
  mdx cube calculation that may need to use some type of subquery

  This sounds like a job for SCOPE. Using the SCOPE statement, you can explicitly modify the SCOPE of a calculation, which should allow you to pull back any data you want in your calculation. There's a blog post I wrote here about using SCOPE. Here's a foru

  Author:  DustinRyan     Date: 7/20/2010     Section: Forum
• 
  Formate Date cell in excel

  If you mean that you need the date formatted a certain way within Excel, you'll likely need to use a scripting task against the Excel model to change the datetime format. If I remember correctly, Excel seems to default to hh:mm:ss in displays of date/time

  Author:  paschott     Date: 8/11/2010     Section: Forum
• 
  Disable multi-select in slicer or filter??

  For something like that, looks like you'll have to do some custom coding via VBA: http://www.databison.com/index.php/slicer-vba-code-create-change-or-modify-a-pivot-table-slicer-using-vba/

  Author:  sqlchicken     Date: 8/10/2011     Section: Forum

  tags : scripting, Slicers, VBA
• 
  xml data flatenning to a relational warehouse

  Hi all, Iam having a source file for my datawarehouse as xml canonical structure.This xml file is of complex hierarchial structure with many complex elements which establish the hierarchy and maintain the relational intigrity between different datasources

  Author:  siddu2010     Date: 1/8/2011     Section: Forum
• 
  Setting a log file to the windows temp folder

  Ok I have done that. So on another computer the log file will move to that new temp location. Since I will not be using the package at the location the user name will be different and that will passdown correctly with out any scripting then right?

  Author:  GaryMazzone     Date: 7/14/2010     Section: Forum