Adverts

It’s finally that part of the release when you see the end of the tunnel and there seems a good reason (or close to it) that your hair has lost more color this cycle…. we’re close to shipping! With that, of course, the marketing machine churns faster. Some results (IMO) are less than stellar: the…


SSIS @ PDC

At PDC this year, Sergei and I will be presenting a session on how to extend Integration Services. This is a 400 level course so will go into more details than the 300 level webcast I did earlier this week for MSDN. Sergei has been the developer who gave us a lot of the extensibility that…


Extending SSIS webcast later today

At 1PM PST today, I’ll be doing an MSDN Webcast on how to extend Integration Services including how to write new tasks and create new components. Why would you want to do that? Well, the simplest example would be if you have binary files that only you know how to read or have other existing…


New Blog Location

Hi there, I’m a member of the SQL Server Integration Services team and previously had a blog here: sqljunkies. Last week I ran into issues posting there and thought I’d try out this site instead. Since I work to integrate technologies, getting blogs over from sqljunkies over to this site is a great problem to…


SQL: Performance of incremental bulk insert

Bulk loading into a table that already has records is a common scenario. A lot of folks ask how can they optimize this, and besides the standard ‘it depends’ answer, there’s a BOL topic that gives useful information on what to do depending on how large your new load is relative to how much data…


SSIS: Logging in pipeline components

Ethan from AMB Dataminers had a great question about how to do logging through his pipeline component.   One way to do it is to call the Fire* methods that’s on the IDTSComponentMetadata90. However, that does incur the cost of basically firing an event and handling an associated event handler. That’s appropriate at times, while…

1