Michael Entin's notebook

Michael Entin's notebook

Posts
  • Michael Entin's notebook

    Running SSIS package programmatically

    • 22 Comments
    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...
  • Michael Entin's notebook

    Why do I get "product level is insufficient..." error when I run my SSIS package?

    • 20 Comments
    The error tells you that you have not installed SSIS on the machine where the package is running - probably you've only installed SQL Server and Workstation Components. Another possible reason is that the package uses components that require higher edition of SQL Server....
  • Michael Entin's notebook

    Where is my SQL Server Integration Services package running?

    • 11 Comments

    By 'where package is running' I mean what CPU and memory resources are used, and where the SSIS needs to be installed. This simple question surprisingly often confuses users, as there are many options to store packages and many options to run it.

    ...
  • Michael Entin's notebook

    Why Debug command is disabled for my SSIS package?

    • 2 Comments
    Debugging support for SSIS packages is probably one of the best features of the SSIS 2005 designer, but sometimes you may find that "Debug" and "Start without Debugging' commands are grayed out. Why? The reason might be obvious to developers who worked with Visual Studio, but hard to find to people coming with DTS experience. In Visual Studio the debugging facilities are provided by the project, so you can't debug if you opened a .DTSX file standalone, without a project....
  • Michael Entin's notebook

    Using C# 2.0 iterators to simplify writing asynchronous code

    • 5 Comments
    A neat idea how C# 2.0 iterators can simplify the task of writing code that uses .NET async pattern. I’ve recently attended Jeffrey Richter’s class dedicated to effective threading techniques, and that made me think about using the .NET async pattern...
  • Michael Entin's notebook

    COM references within an SSIS Script Component

    • 2 Comments
    The SSIS Script Task and Script Component editors don't provide functionality (available in full VS) to add a reference to unmanaged COM components. Can this be done at all? Well, yes, although lack of GUI option in VSA (which SSIS uses for editing...
  • Michael Entin's notebook

    Using C# 2.0 iterators to simplify writing asynchronous code (part 2)

    • 8 Comments
    Previous article describes the idea of using C# 2.0 iterators to write asynchronous code, now it's time to implement the utility class that "runs" the iterator. The utility turns out to be very light, I'm glad some readers reported they've already implemented...
  • Michael Entin's notebook

    SQL 2008 & VS 2008

    • 5 Comments
    Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don't try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 - now that Visual Studio 2008 is released - what are the plans for BIDS and support of BI projects VS 2008?...
  • Michael Entin's notebook

    Redirecting output of Execute Process Task

    • 1 Comments
    Can you guess why this does not work? A customer is trying to use the Execute Process Task to execute the preplog.exe application (Microsoft utility) and pass the following command-line arguments: inetsv1.log > inetsv1.txt. Expected result...
  • Michael Entin's notebook

    Katmai SSIS data flow task improvements

    • 4 Comments
    With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release......
  • Michael Entin's notebook

    Deploying packages

    • 0 Comments
    How can one deploy packages programmatically? Here is the original question - Is it possible to deploy a package programmatically? We have an application which has a work flow for approval of object. If the object (ssis package) is approved by the...
  • Michael Entin's notebook

    Custom transforms: determining end of rowset

    • 3 Comments
    It appears like a EndOfRowset property of SSIS buffer is being often used incorrectly, which could cause problems when you move the code to SQL 2008. Unfortunately, some Microsoft docs helped to spead this error, so let me clarify what it means and how it should be used....
  • Michael Entin's notebook

    64-bit references within an SSIS Script Component

    • 1 Comments
    I was forwarded a question about SSIS Script Component on 64-bit, I think the answer may benefit others as well: Currently we are referencing a 32-bit third party component in a script component and running the SSIS package in 32 bit mode on a X64...
  • Michael Entin's notebook

    SSIS Lookups modes or leaky abstractions

    • 4 Comments
    I've got a question about SSIS Lookup, how-to change Partial or No_Cache mode in Lookup task ? I could give a quick answer, but wanted to explain what I think we did wrong in SQL 2005, and how are we planning to fix this. Before continuing...
  • Michael Entin's notebook

    Lookup multiple rows?

    • 3 Comments
    Can SSIS Lookup do what this user wants it to do? I have a problem with a lookup output, I get this warning: The Lookup transformation encountered duplicate reference key values when caching reference data. I know what it is, but I don't like to...
  • Michael Entin's notebook

    Computer display size calculator

    • 0 Comments

    Surprisingly, could not find quick tool to compare various screen sizes and resolutions, so here it is.

    ...
  • Michael Entin's notebook

    SSIS Backpressure Mechanism

    • 0 Comments
    One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge...
  • Michael Entin's notebook

    Don't run SSIS package using SQL/CLR

    • 0 Comments
    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...
  • Michael Entin's notebook

    Configuring .NET for running SSIS packages from custom applications

    • 1 Comments
    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 do you know what is good? The simplest way is to look at the config file that SSIS provides, and copy the appropriate settings. Now let's take a look at DTExec.exe.config provided with SQL Server 2008 and discuss the choices made by SSIS team. ......
  • Michael Entin's notebook

    Application termination when user logs off

    • 7 Comments
    Do you know how windows terminates all the applications when user logs off? I did not think too much about this, and assumed that it is a normal process - after all the WM_QUERYENDSESSION and WM_ENDSESSION processing, the application main window closes, posts WM_QUIT and the application quits in a regular way. But a recent bug reported for one of my GUI applications caused me to look deeper. The bug caused the application settings to be lost, and this made me look closer at what happens at logoff. ...
  • Michael Entin's notebook

    Does buffer.NextRow() skips the first row in a buffer?

    • 1 Comments
    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:...
  • Michael Entin's notebook

    The way NOT to write HTTPS server

    • 0 Comments
    Note: posted under rant tag, so you are warned ;) I've just got a new wi-fi router, DIR-655 from DLink. Seems like a nice router, but at least one feature is just plain horrible broken. And it is security feature, which makes me wonder how secure the...
  • Michael Entin's notebook

    VALVe/Steam horrors

    • 0 Comments
    I run Vista on my home PC (and at work too, actually), and all of us run as non-admins (not Vista's protected admin, but real non-admin). My son plays Counter Strike, and thus has to run Steam. It worked mostly fine, until recently it started to ask to install Steam as a service. Well, a service for internet-facing software seems not good. Before installing, I decided to find out more about it, and the finding are much worse than I've ever expected ......
  • Michael Entin's notebook

    Network causing SSIS package startup delays?

    • 0 Comments
    This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in the context of SSIS service it has a KB article . But I still see forums posts and private questions that show that not all SSIS users are aware of...
  • Michael Entin's notebook

    SSIS event handler threading

    • 0 Comments
    If the package has an event handler that can handle multiple events, and these events fire at about the same time. What happens? ...
Page 1 of 2 (43 items) 12