Metadata tool and whitepaper for BI components

Hi again, Over the last few months a lot of you have expressed a need to do impact analysis and lineage investigations across the different BI components we’ve got…. if I change this table here what packages, cubes, reports will be affected. Well, earlier this week the BI team released a metadata pack that you…


Biztalk, SSIS, Indigo, SSB, AAAAA!

This is a FAQ that we get at least once every time we present. I got it last week doing launch activities in Portugal, and then earlier today on a webcast on extending SSIS. For those not familiar with the excellent whitepaper on this, check this one out: regards



As you know, we just declared SQL RTM earlier today. For those familiar with the changes in this release, my goodness. This has been a huge release. I’ve had a kid along the way, some have had two. Shipping software of this magnitude is probably one of the most gratifying experiences, and I had to…


SSIS: Lookup from Text Files

Ever want to do a lookup on a text file without putting it in a database or using a merge join? Grant from the Project REAL team found a great nugget: Openrowset now allows the BULK clause to be specified which accepts a filename and format specification. An OLE-DB driver for flat-files or XML would…


SSIS: Debugging foreach NodeList enumerators

Earlier today Fred S. asked a great question. “Using the following data I’m trying to get each node Element populated into their own variables.XML: <DataBases>   <DataBase>      <Name>Sales</Name>      <Action>DBCC</Action>      <FLOP>1</FLOP>   </DataBase>   <DataBase>      <Name>Inventory</Name>      <Action>DBCC</Action>       <FLOP>1</FLOP>   </DataBase></DataBases> Want to do:Name   -> vsDataBase     Action -> vsAction       FLOP   -> vnFLOP                       Where vsDataBase, vsAction and vnFlop are variables of…


SISS: Providing parameters when providers don’t support them

This has come up a few times recently, and I couldn’t find the information for them in the usual sources. The desire that some folks have is to support parameters in their SQL statements. Sounds reasonable. The OLEDB source, for example, supports parameters. However, some providers don’t support derivation of parameters from a statement. The…


SSIS Best Practices – Performance

We’ve been slowly creating a list of best practices. Simon asked me about these at the PDC a couple of weeks back. It’s time to share them out not just to make folks aware of them but also to solicit other goodness you’d like us to include in the official list. First off, Performance:   [Oledb…


"It is illegal to call out while inside message filter."

One of our ISVs ran into an issue that others writing managed code interoping with COM (nothing to do with SSIS directly) might run into. At some unpredictable time, he got an error message with the title of this blog entry while working in the designer. I couldn’t find good information on the net on…


DTS/SSIS and debugging mysterious relational engine deadlocks

Over the last few days I’ve learnt a lot in how to debug SQL hangs thanks to Sunil from the SQL Server engine team. For one of the customers last week, the problem seemed to be that their DTS2000 package worked great with SQL2000. However, upgrading the relational engine to SQL2005 and making the DTS2000…


SSIS: Handling lookup misses

It’s typical in data warehouse loads to have lookups that go against dimension tables. If the key doesn’t exist, either a new one is created, or a default value is used. There’re two ways to do this: 1. Lookup is configured to redirect rows that have no match in the reference table to a separate output…