Blog - Title

  • SSIS Team Blog

    EzAPI – Alternative package creation API

    • 35 Comments
    SSIS provides APIs to programmatically create dtsx packages. While we provide a managed wrapper layer for the runtime/control flow, you have to use the lower level COM wrappers (DTSPipelineWrap) to create your data flows – the usability of which could...
  • SSIS Team Blog

    Roll your own Transfer SQL Server Objects task

    • 28 Comments
    Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task. Some of these turned out to be bugs, but a lot of the reported issues stemmed from usability problems with the task...
  • SSIS Team Blog

    Lookup Pattern: Range Lookups

    • 27 Comments
    Performing range lookups (i.e. to find a key for a given range) is a common ETL operation in data warehousing scenarios. It's especially for historical loads and late arriving fact situations, where you're using type 2 dimensions and you need to locate...
  • SSIS Team Blog

    Using XML Source

    • 22 Comments
    Providing a generic way to extract data from XML documents of any format is pretty complicated. The SSIS XML Source Adapter tries to do just that, to various degrees of success. XML Source is easiest to use when your input has a simple element/sub-element...
  • SSIS Team Blog

    What’s New in SSIS for SQL Server 2012 RC0

    • 20 Comments
    At the 2011 PASS Summit I presented a Top 10 list of features that had been added since CTP3 , or hadn’t gotten much attention so far. Now that the SQL Server Release Candidate 0 (RC0) available , I can start blogging about them! I’ll continue to post...
  • SSIS Team Blog

    Connecting to MySQL from SSIS

    • 19 Comments
    Update: See this follow-up post on writing data to MySQL . I've recently seen a bunch of questions about connecting to MySQL from SSIS, so I thought I'd give it a try. My overall findings was that while there were quirks, both the ODBC and ADO.Net...
  • SSIS Team Blog

    SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online

    • 18 Comments
    Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual...
  • SSIS Team Blog

    Script Component Debugging in SSIS 2012

    • 17 Comments
    In SQL Server 2012, you can now debug the Script component by setting breakpoints and running the package in SQL Server Data Tools ( replaces BIDS ) . When the package execution enters the Script component, the VSTA IDE reopens and displays your...
  • SSIS Team Blog

    SSIS - What’s New in SQL Server Denali

    • 17 Comments
    What’s new in SSIS? In a word: Lots . It’s been a lot of fun showing off the new SSIS features and functionality – the hardest part has been fitting it all into a 60 minute timeslot. This CTP is close to feature complete – the...
  • SSIS Team Blog

    SSIS and PowerShell in SQL Server 2012

    • 15 Comments
    This post is from Parth Shah, a Software Development Engineer in Test on the SSIS Team. Previously we have talked about SSIS Catalog Managed Object Model . For those of you don’t remember what MOM is or have not heard of it before, think about MOM as...
  • SSIS Team Blog

    CDC for Oracle in SQL Server 2012

    • 15 Comments
    One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables. Configuring...
  • SSIS Team Blog

    Writing to a MySQL database from SSIS

    • 15 Comments
    A couple of users reported being unable to use the ADO.NET destination to insert data into their mysql databases. When I originally tried this out , it worked, but it seems like changes made since the early 2008 CTPs have made us incompatible with MySQL...
  • SSIS Team Blog

    New connectivity options in 2008

    • 14 Comments
    Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008 Update: 2008-10-02 - The Oracle and Teradata connectors are now available Update : 2008-11-26 - The SAP BI connections are available Darvey...
  • SSIS Team Blog

    Accessing a data profile programmatically

    • 14 Comments
    The new Data Profiling Task in 2008 generates an XML output file. The output is easy to read, and could be used to make decisions within a control flow. For example, you could check whether or not to process your most recent data set based on criteria...
  • SSIS Team Blog

    Attunity connectors for Oracle and Teradata are now available

    • 14 Comments
    The high speed connectors for Oracle and Teradata are now available for download .   Supported versions Platforms Oracle 9.2.0.4 or higher x86, x64, ia64 Teradata 2R6.0, 2R6.1, 2R6.2 and 12.0 x86, x64 Attunity has done a great job putting these together...
  • SSIS Team Blog

    Accessing OLEDB Connection Managers in a Script

    • 13 Comments
    Accessing ADO.Net Connection Managers from an SSIS script task / script component is pretty easy – you just need to cast the object returned from AcquireConnection() to the appropriate class (i.e. SqlConnection if you’re using SQL Native Client). SqlConnection...
  • SSIS Team Blog

    Why can’t I store my BIGINT result in an Int64 variable?

    • 13 Comments
    The native providers (OLEDB, ODBC, ADO – ADO.NET doesn't have this problem) in the Execute SQL Task return the BIGINT type as a String, and not an Int64 as you'd expect. Attempting to store the result in an Int64 variable gives you an error along the...
  • SSIS Team Blog

    XML Source - Making things easier with XSLT

    • 12 Comments
    As I wrote in my previous post , complex XML documents will produce multiple outputs when you're using the XML Source adapter. Most of the time it will be easier to pre-process your source file with XSLT to de-normalize it a bit. Reducing the number of...
  • SSIS Team Blog

    What's new in SQL Server 2008 for SSIS - Part one

    • 12 Comments
    Improved Scripting SQL Server 2008 (Katmai) introduces VSTA as our new scripting engine, which replaces the old VSA engine used in SQL Server 2005 (Yukon). There are a number of advantages to the new engine, but I think the feature users are most excited...
  • SSIS Team Blog

    SSIS and Visual Studio 2010

    • 12 Comments
    UPDATE 2013-03-25 : To clarify, VS2010 support was added in the SQL 2012 release. We also support VS 2012 . --- There was a very lively connect issue about SSIS’ lack of support for VS 2010. Jeff Bernhardt recently posted an official reply...
  • SSIS Team Blog

    Overview of the DQS Cleansing Transform

    • 12 Comments
    Data Quality Services is a new SQL Server product in Denali which provides data cleansing capabilities. This post describes how to make use of the DQS Cleansing Transformation which is part of the default set of SSIS data flow components. The DQS Cleansing...
  • SSIS Team Blog

    Lookup cache modes

    • 11 Comments
    Over the past couple of months I've been putting together a presentation on the Lookup Transform. I presented most of it as a Chalk Talk at the MS BI Conference last week, and from the evaluation scores, it seems like it was pretty well received. I'll...
  • SSIS Team Blog

    Upcoming Product Changes

    • 10 Comments
    We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some of exciting new functionality we’ve introduced to SSIS. Over the new few months (starting about the time the first public CTP drops), I expect you...
  • SSIS Team Blog

    The Pivot Transform – Now with UI!

    • 10 Comments
    One of the post-CTP3 changes for SSIS in SQL Server 2012 is the addition of a user interface for the Pivot transform. This post walks through the new UI, which can be found in the new RC0 preview release. Sample Data For this example, we’ll be pulling...
  • SSIS Team Blog

    A Glimpse of the SSIS Catalog Managed Object Model

    • 9 Comments
    Today’s post is from Ke Yang – a developer on the SSIS Team based in Shanghai. It provides a quick overview of the new Managed Object Model (MOM) for the SSIS Catalog. --------------------------------------- The namespace Microsoft.SqlServer.Management...
Page 1 of 10 (239 items) 12345»