July 2005 - Posts

• 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. Read More... Posted Thursday, July 28, 2005 4:51 PM by Ashvini Sharma [MSFT] | 0 Comments

• 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 Read More... Posted Wednesday, July 20, 2005 5:25 PM by Ashvini Sharma [MSFT] | 0 Comments

• 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 Read More... Posted Monday, July 18, 2005 7:49 AM by Ashvini Sharma [MSFT] | 0 Comments

• 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 Read More... Posted Friday, July 15, 2005 6:19 PM by Ashvini Sharma [MSFT] | 0 Comments

• 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 Read More... Posted Friday, July 15, 2005 6:08 PM by Ashvini Sharma [MSFT] | 0 Comments

• 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 Read More... Posted Saturday, July 16, 2005 12:59 AM by Ashvini Sharma [MSFT] | 1 Comments