THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql server » SSIS   (RSS)
Showing page 5 of 5 (48 total posts)
  • The SQL developer gap (Warning: rant coming up)

    I recently submitted a bug to Microsoft Connect concerning the behaviour of the expression language in SSRS, if you’re interested you can read about it here: DateAdd() doesn't throw an error when it has invalid parameters. I got a swift and detailed reply (for which I am grateful) from a fellow on the SSRS team however the content of it wasn’t ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2010
  • Twitter Search Term Extraction

    During my presentation A whistlestop tour of SSIS addins yesterday at SQLBits I demonstrated how Jessica Moss & Andy Leonard’s Twitter Task could be used in conjunction with SSIS’s Term Extraction component to discover what people might be saying in their replies to a Twitter user. The Term Extraction component is a little-known and ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 22, 2009
  • Sort transform arbitration [SSIS]

    This post was prompted by a thread on the MSDN SSIS forum today where the poster was asking how he could replicate the behaviour of SSIS’s Sort transform using T-SQL, specifically he wanted to know how the Sort transform chooses what data to pass through when the “Remove Duplicates” option is checked. Let me give a bit more background. Take the ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 12, 2009
  • Things you might not know about Precedence Constraints : SSIS Nugget

    Precedence constraints are one of the most oft used features of SQL Server Integration Services (SSIS) but also often one of the most overlooked. In this blog post I’ll cover a couple of things that you might not know about them. The basics Most people typically use precedence constraints like this, with a green arrow: A green arrow here ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 10, 2009
  • SET IDENTITY_INSERT little bug(?)

    While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create my packages. I’ve found that, when working on an empty table that has an identity column, if ...
    Posted to Davide Mauri (Weblog) by manowar on September 30, 2009
  • SSIS: living in a parallel world? Not yet...

    Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 14, 2008
  • Making Fast Load really fast on clustered indexed tables with SSIS

    I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered that int identity primary keys are among the slowest way to insert huge amount of data with ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 8, 2007
  • SSIS: ForEach Looping through a recordset

    I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly from writing a tutorial on how to do RSS feeds with SSIS earlier that I am not sure ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2007
Privacy Statement