Search Results: programmatic

• 
  Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool

  This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using a Script Task component

  Author:  mafiswana     Date: 3/25/2012     Section: Article

  tags : C#, create package, C-Sharp, Data Flow Task, dynamic, Flat File, OLE DB, OLE DB Destination, package, programmatic, script task, SQL Server, SQL Server 2008, SQL Server Intergration Services, SSIS, SSIS package, Text File
• 
  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
• 
  Migrate Data - Programmatically

  Hi All I want to develop an SSIS Package to migrate data programmatically. Here is the requirement: Every week client will provide me list of tables which are same on source and target server/database. He will also ask me to ignore or include particular c

  Author:  bkvikas     Date: 6/10/2010     Section: Forum

  tags : data migration, programmatically, ssis
• 
  Dynamic Parameter Name

  Hi, I have a report with cascading parameters. I would like for the selection of the first parameter value to not only filter the list for the 2nd, but also dynamically change the 2nd parameter display name. Is there any way to do this programmatically wi

  Author:  jjs781     Date: 6/8/2012     Section: Forum

  tags : dynamic, parameters, prompt
• 
  Determine SSIS Execution Order Programmatically

  How do I determine the execution order or parent/child relationship of each object in an SSIS package? I am extracting data out of my SSIS 2008 packages programmatically using SqlServer.Dts.Runtime. I have all the data already. I am now trying to figure o

  Author:  MrPerson     Date: 2/27/2011     Section: Forum

  tags : SqlServer.Dts.Runtime, ssis
• 
  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
• 
  Launch Remote SSIS Package Programmatically

  It can be a pain to launch an SSIS package remotely. So I developed a vb.net standalone application to remotely launch a package. It does require the host computer to have SSIS installed. This is just a beginning program. I am going to be adding other fea

  Author:  MikeDavis     Date: 11/12/2009     Section: Blog

  tags : Launch Remote SSIS Package Programmatically
• 
  building a Send Mail Task without a predefined SMTP Connection Manager

  I have a xml configuration file indirectly referred to via an environment variable. The file includes SMTP and other email-related information. When I tried to build a Send Mail Task that pulls SMTP, MailTo, and MailFrom from variables in the config file

  Author:  Christian     Date: 9/27/2010     Section: Forum

  tags : configuration files, send mail
• 
  Connection Managers are giving me fits

  Keith, Thanks for your reply. It was very helpful. Bottom line: one DOES need to create/instantiate Connection Managers during the design process. What you solved was how to set the connection string programmatically from variables loaded from a config fi

  Author:  Christian     Date: 9/30/2010     Section: Forum
• 
  Connection Managers are giving me fits

  Connection Managers are giving me fits. (I have a related post on "building a Send Mail Task without a predefined SMTP Connection Manager".) I'm working in the BIDS Designer. To ease the transition from dev to production my thought was to build an xml con

  Author:  Christian     Date: 9/29/2010     Section: Forum

  tags : Connection Managers; setting them programmatically
• 
  Exporting to PDF - landscape vs. portrait

  Brit, Unfortunately, the landscape settings are not capable of dynamic switching. Also note that even if you could switch it dynamically, the exporting to pdf function creates one pdf file. As such, the pdf file is either/or. Now I believe that I have see

  Author:  briankmcdonald     Date: 7/19/2010     Section: Forum
• 
  How to iterate over package precedence constraints programattically?

  I am trying to iterate over all the precedence constraints in one of my packages. I can iterate through everything else just fine. Even the precedence constraints for containers (sequence, for loop, for each...). I dont see a way to get the precedence con

  Author:  MrPerson     Date: 7/21/2010     Section: Forum

  tags : api, constraints, integration services, loop, package, precedence constraints, programmatically, ssis, task, taskhost
• 
  Change ConnectionString from C# Code

  Iam new to SSIS & i need help to change ADO.NET connection string Programmatically. I Have a SSIS packge with a ADO.NET connection(Source). When i try to change its ConnectionString via C# code,the package fails. i get an error saying COnnection Manag

  Author:  thenewbee     Date: 7/10/2010     Section: Forum
• 
  One Flat file to multiple tables

  Hi Marco I opened up the Data Flow Destinatin and the table name can't be set as a variable, which surprised me actually. The other way of doing this is to add references to the SSIS dlls inside your applications, and programmatically create the objects.

  Author:  MarkGStacey     Date: 7/18/2010     Section: Forum
• 
  Custom Security Plug-ins? Possible?

  New in SSAS 2008 is a full suite of AMO objects in .NET allowing programmatic control of almost every featuer in SSAS. I have a lot of clients taking advantage of this to extend SSAS and provide additional customization to automation, security, etc.. One

  Author:  AdamJorgensen     Date: 12/11/2009     Section: Forum
• 
  Generate Image of Package Programmatically

  Can anybody point me to any info about programmatically generating an image of my packages? --Cam

  Author:  MrPerson     Date: 9/30/2011     Section: Forum
• 
  Generate Image of Package Programmatically

  I am looking to essentially take a screenshot of the package... but do it programmatically from the package itself. Yes BiDocumenter (found at http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx) does has this functionality

  Author:  MrPerson     Date: 10/2/2011     Section: Forum
• 
  Dynamically sizing reports in SSRS

  I don't think you'll be able to dynamically size the report outside of doing it programmatically. See this link: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9e6043f1-c458-4540-be59-d37b02feab8a You should, however, be able to

  Author:  DustinRyan     Date: 4/13/2010     Section: Forum
• 
  Dynamic report width

  Using SSRS 2008 R2, if I programmatically hide a column, how can I shrink my report width to match the now smaller tablix width? Thanks, Rob

  Author:  rgtft     Date: 9/4/2012     Section: Forum
• 
  How to remove the last line in a text file using SSIS

  I have successfully downloaded a file via web connection using a script task. HOWEVER, at the bottom of the text file is the word SUB and its throwing off my bulk inserts into SQL Server. How can i programmatically delete the SUB word at the end of the te

  Author:  Al_Gore_rythem     Date: 12/20/2012     Section: Forum