Finally!

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…

0

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…

2

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…

4

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…

2