Michael Entin's notebook

Michael Entin's notebook

Browse by Tags

Tagged Content List
  • Blog Post: SSIS custom component performance tidbit

    I was helping a friend of mine to debug performance issue with his SSIS package. The package was pretty simple – he needed to read data, shard it using some partitioning scheme, then insert the results into 8 SQL destinations. The hashing algorithm used for partitioning was rather complex for conditional...
  • Blog Post: Does buffer.NextRow() skips the first row in a buffer?

    I got a follow up question to my old post regarding enumerating rows in SSIS buffer , that suggested using following code to process rows in custom SSIS transform: while (buffer.NextRow()) {   // do something with the row } Here is the question: buffer.NextRow() moves the pointer forward, so following...
  • Blog Post: Configuring .NET for running SSIS packages from custom applications

    If you execute SSIS packages from custom applications, you own the application and thus you are responsible for configuring .NET runtime properly to get the maximum performance. .NET configuration is usually performed using .exe.config files, so it is a just matter of providing good config file. How...
  • Blog Post: Don't run SSIS package using SQL/CLR

    A recent commenter suggested running SSIS using SQL/CLR: Just an idea on how to do this that may be a bit easier than any of the methods covered. IF you were to write a CLR procedure which accepts a string as its parameter. The string passed in would be the xml definition of a package (either loaded...
  • Blog Post: Using SSIS object model from C++

    All the samples in MSDN show how use SSIS API from C# or VB.NET code. Is it possible to do this from C++ code? The answer is yes, if you know COM it should be quite easy for you, and the COM API is very close to .NET API (I think .NET API is nicer due to rich type system and properties). Note that...
  • Blog Post: Running SSIS package programmatically

    I got several questions asking what is the best way to run SSIS packages programmatically. One question is about running SSIS from a .NET 1.1 application (SSIS uses .NET 2.0). Another about running package remotely "Do I really have to write an ASP.net app just to run a package on the server?" There...
Page 1 of 1 (6 items)