THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS   (RSS)
Showing page 48 of 49 (484 total posts)
  • Long life to TableDifference

    It seems that Microsoft will not improve the slow SCD component that is part of SSIS (at least, this is what I understand from this Microsoft Connect answer). This means that TableDifference has a long life because it will be useful even in SQL Server 2008. The versione 1.2 beta of TableDifference still needs some test because there is a latent ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 8, 2007
  • SSIS Script Task In SQL Server 2008 Can Use VB Or C#

    Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out that SSIS in SQL Server 2005 uses VSA (Visual Studio for Applications) but SQL Server 2008 will ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 4, 2007
  • Is Microsoft serious about BI?

    The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought about this many times before writing this post, because I want to be constructive and I hope that my words will not be misunderstood. My consideration start from the lack of a BI client. If Microsoft want BI for the masses, a low-cost end-user ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 26, 2007
  • The need for a better merge component in SSIS

    Alberto Ferrari wrote an interesting post about the need of more properties to control the behavior of a Merge component in Integration Services (SSIS). This apparent simple problem becomes very important in large data warehouses. I hope that someone in Redmond will consider all these possible improvements...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 10, 2007
  • 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
  • FastLoad option on SSIS with int identity as primary key

    Alberto Ferrari posted some test we made working on performance optimization loading data in very large dimension tables. When we discovered that an int identity primary key is not handled by SQL Server just as an ordered set of data in a bulk operation... we had to triple check the whole thing. I would like to know if there is a way to bulk ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 8, 2007
  • 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
  • Enable multi-phase data pump in DTS editor (Management Studio)

    If you edit a legacy DTS package with SQL Server Management Studio, you may want to know how we can show the multi-phase data pump operations. I haven't found an option to do this with SQL Server Management Studio. However, when you need to do something, you find a way to do that thing... I found that necessary setting can be controlled through ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 11, 2007
  • How to get Distinct Count in SSIS

    Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU. The most used way to get distinct rows in a Data Flow  that I've seen is to use the Sort component, asking only for distinct rows (there is a check box for that in the standard edit dialog box). The Sort ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 9, 2007
  • A Distinct Component for SSIS

    Alberto Ferrari has published on SQLBI.EU a Distinct component for SSIS. The big advantage is less memory used when you have few distinct values extracted from a large set of data. Component and source code are freeware. Now the challenge is: how to improve the algorithm? Goals: more fast, less memory consumption...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 12, 2007
Privacy Statement