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 » SSIS   (RSS)
  • 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
  • Mantaining order in SSIS flow, problems with Merge

    In a previous post I spoke about the advantages of having sorted flows in SSIS to greatly speed up data insertion using fastload. The need to have a sorted flow brings some severe problems to the SSIS programmer that he need to be aware of and that IMHO Microsoft should address with a future implementation of SQL Server. Let’s have a look at the ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 10, 2007
Privacy Statement