October 2005 - Posts

• 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 Read More... Posted Thursday, October 27, 2005 2:09 PM by Ashvini Sharma [MSFT] | 0 Comments

• 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. Read More... Posted Monday, October 24, 2005 12:33 PM by Ashvini Sharma [MSFT] | 2 Comments

• 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> Read More... Posted Friday, October 21, 2005 7:06 PM by Ashvini Sharma [MSFT] | 2 Comments

• 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. Read More... Posted Thursday, October 20, 2005 11:44 AM by Ashvini Sharma [MSFT] | 2 Comments