Search Results: C#

• 
  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
• 
  Default Bids to use VB or C#

  As you can see below you can default Bids to use VB or C# as the default script language for your SSIS packages. This can be handy if you have a preference in your code language and always forgot to change it. If you forget to change it before you click o

  Author:  ChrisAlbrektson     Date: 2/28/2012     Section: Blog

  tags : BIDS, C#, Default Code Language, VB
• 
  .NET cross platform possibilities

  .NET Developers…, It is time to (seriously) think about cross platform development. I recently went searched for Mono…the Linux port of the .NET Framework. Rewind to about four years ago…the implementation was not that extensive, etc., etc. Fast forward b

  Author:  RobertHarris     Date: 2/4/2011     Section: Blog

  tags : Android SDK, C#, iOS, Linux, MacOS, Mono.NET, Samsung, UNIX, Visual Studio 2010, .NET
• 
  SQL Server 2012 - Choose Function

  As I've shown in my previous posts, there is a bunch of new functions and features with SQL Server 2012. In this thread, I would like to show you how to use the new logical function which select and return data from a specific index of a list of supplied

  Author:  marcoadf     Date: 12/28/2011     Section: Blog

  tags : 2012, case, Choose, Denali, function, IIF, logical, Server
• 
  SSIS 2008 Setting proper case with a Script Component

  There is a command in VB that can be used to character data to proper case. This is the first letter of each word is capitalized and the rest is lower case. This is a great way to clean up a data base or is great to use when loading a data warehouse. Drag

  Author:  MikeDavis     Date: 2/17/2010     Section: Blog

  tags : .NET, 2008, c#, ProperCase, Script Component, VB, sss
• 
  Using Messages to Navigate in an MVVM Structure

  As a C# Noob, I've pretty much thrown myself in head first with my latest project. However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good reason). I won't go into detail about what MVVM is, or why it can h

  Author:  RCharCox     Date: 2/21/2013     Section: Blog

  tags : C#, GalaSoft, MVVM, navigation, programming, XAML
• 
  Setting proper case in SSIS with a Script Task

  The Derived column transform can make a lot of changes in a data flow in SSIS. In about 95% of the time the derived column can take care of any data cleansing issues with text changes. There is one thing that is does not have and that is proper case. The

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

  tags : C#, Proper Case, Script Transform, VB, SSIS
• 
  Help with Script Component Issue

  The Script Component does not support the use of breakpoints. Therefore, you cannot step through your code and examine values as the package runs. There are a few workarounds to still get some form of debugging. // C# Code System.Windows.Forms.MessageBox.

  Author:  SSISJoost     Date: 4/5/2011     Section: Forum

  tags : DEBUG, SCRIPT component, SSIS
• 
  Parent/Child Help

  You've got a few options with SSIS. You could "do the work" in T-SQL as an execute SQL task. One method would be modifying something like what is shown here: http://www.sqlservercentral.com/scripts/Miscellaneous/31913/ - I'd use a regular table instead of

  Author:  KeithHyer     Date: 5/17/2011     Section: Forum

  tags : pivot, script task destination, delimited string
• 
  Generate Image of Package Programmatically

  Cam, A site primarily dedicated to Business Intelligence may not be your best source for learning how to program in C#. You may have better results, so you may want to post a similar question at http://www.tek-tips.com/ . However, I just researched a litt

  Author:  briankmcdonald     Date: 10/2/2011     Section: Forum

  tags : C# development, dynamically generating images
• 
  Add Code39 barcode generation function into local reports

  The RDLC barcode library is used for adding Code 3of9 generation features into local reports. To generate Code 39 barcode images in RDLC reports, the Code 3 of 9 barcode library should be used as a custom assembly into the local reports Code section for V

  Author:  KeepDynamic     Date: 12/13/2012     Section: Forum

  tags : barcode, Reporting Services
• 
  Populate data in the table from multiple csv files

  If you have a requirement to keep each part of the import in an SSIS package - you might consider a script task to concatenate the rows - or a ScriptTask data source component ( within a data flow ) and let some C# / VB.Net code do the heavy lifting on th

  Author:  KeithHyer     Date: 5/24/2011     Section: Forum

  tags : concatenate, CSV, optimization
• 
  Stored Proc: xp_cmdshell to exec dtexec utility

  Hi all ! I hope this is the correct forum for this type of question. Here's a synap of my program. 1. C# GUI calls Stored Procedure 2. Stored Procedue Executes xp_cmdshell 3. xp_cmdshell Executes dtexec SSIS.dtsx package (Sql Server 2008, BIDS, SSMS, Win7

  Author:  JohnG     Date: 7/28/2010     Section: Forum

  tags : dtexec, sql agent job, ssis
• 
  SSIS 2005 - Data Flow work to be done in a dynamic way - Need Help

  I had a project a while back to do something similar with 135 EBCDIC mainframe files. Instead of doing the work in SSIS, I did it in VB.Net 2005 - I used text files which have the file definition to dynamically create pre-configured SSIS packages to do th

  Author:  KeithHyer     Date: 1/25/2011     Section: Forum

  tags : generated, ssis, vb.net
• 
  Map/Reduce - A Brief Introduction

  Somewhere between teaching a BI Bootcamp class and wrestling my troop of kids, I promised myself I would get a blog post in this week. Luckily, I've had a few code heavy posts, so we will dial it back slightly as I briefly introduce MapReduce for Hadoop/H

  Author:  cprice1979     Date: 4/24/2013     Section: Blog

  tags : Hadoop, HDInsight, Java, MapReduce
• 
  Eight ways of executing SSIS package and passing parameters (T-SQL, VB.net, C#, SQLAgent, DTExec)

  This article will explain how to execute SSIS package using different methods and make package dynamic by passing parameters via commandline or using VB.net/C# API

  Author:  NayanPatel     Date: 12/15/2009     Section: Article

  tags : SQL Agent Proxy SSIS Scheduling Parameter
• 
  Why Query When You Can LINQ

  Why Query When You Can LINQ INTRODUCTION TO LINQ LINQ is a abbreviation for Language Integrated Query, Which is just a fancy way of saying in that while in .net code you can write out your queries as if it were as simple as any other statement in you nati

  Author:  Bevans     Date: 4/27/2010     Section: Blog

  tags : LINQ, SQL Scripting, C#
• 
  send email from data flow

  Thanks. I'm having a hard time finding a code example of how to change a variable value using the script component in C#. I tried doing it on my own, but I'm having some trouble. public override void PostExecute() { base.PostExecute(); IDTSVariables100 va

  Author:  sherz1000     Date: 5/26/2010     Section: Forum

  tags : email, script component, variable, SSIS
• 
  SSIS Component Development Resources

  I'm interested in ( maybe blogging ) developing SSIS components using C#. Has anyone else looked into doing this and if so, what good resources have you found regarding it? Here are a few that I have found and would welcome any additions. MSDN: http://msd

  Author:  KeithHyer     Date: 8/16/2011     Section: Forum

  tags : SSIS Component development, SSIS Components
• 
  Creating and Using a C# Class Library for SSRS

  In this blog post I am going to attempt to show how to create a quick and dirty C# class library as a simple way to provide end-user customization across reports. The sample I will use will be to facilitate Name formatting but this can extended to suit wh

  Author:  JeffRush     Date: 12/20/2010     Section: Blog
• 
  Why the lack of use of .NET Assemblies in the SQL Server BI environment…?

  As powerful of a programming toolset as is the .NET Framework…Having that functionality available to a SQL Server database developers I would think would be well accepted. I would assume (maybe I shouldn’t assume) many database developers would salivate o

  Author:  RobertHarris     Date: 6/28/2010     Section: Blog

  tags : Assemblies, BI Developers, .NET
• 
  Back to Basics Part 2

  In our next lovely episode we will go further into the murky depths of programming. We will namely the biggest differences between the ideologies of transactional languages and programmatic languages. Once again I will primarily be using C#, this is mainl

  Author:  Bevans     Date: 3/25/2010     Section: Blog

  tags : c#, et programming
• 
  SSIS package need help

  Hi Karthick, I have change the code to c#.Script is working well but when package is executed ,squence container ,data flow task and flat file destination failed .so when i removed the squence container, script task failed.data loaded into the flat file b

  Author:  Asmi28     Date: 7/12/2011     Section: Forum

  tags : SSIS Package Design
• 
  Stored Proc: xp_cmdshell to exec dtexec utility

  Update: Sql Agent Job runs a T-Sql query that executes via xp_cmdshell, the SSIS package then imports data into the table. That's the theory, tested doesn't work. Question: can Sql Agent Job execute xp_cmdshell? Eliminations: -- Tested SSIS package with d

  Author:  JohnG     Date: 7/29/2010     Section: Forum

  tags : SQL Agent Job, Stored Procedure, sql agent job
• 
  what all are the possible chances for data from datasource is not copied into excel destination

  Ah, so you want SSIS to figure out based on the procedure you're calling - what the types are set up all of the downstream components / adjust them - and eventually write them to Excel. I think there are some 3rd party components that handle things like t

  Author:  KeithHyer     Date: 1/18/2013     Section: Forum

  tags : dynamic pipeline, variable data type