Yeah, my recollection is that occasionally, I have had to go through this cycle a couple of times over 24 or 48 hours before it worked. Not sure why,...

What you are getting into here is the notorious "Impedance Mismatch" between Object Oriented design and the Relational Model of databases. The issues that you are raising are extremely...

Are you asking in this forum because you wanted to know how to do this with client code using SMO?

I did read the article at your blog, but there were no examples of ISDATE() being unreliable. If you could supply some examples of ISDATE()...

We are going to need the column definition of [Firstdisbursementdate] and some examples of its typical content.

I hope that this means that you are not going to use CONTEXT_INFO, it is a seriously bad idea.

You might want to move this to the "SQL Server 2005 Integration Services" forum in the Sql server 2005 group.

Well fof Service Broker, you can start at my blog: download the zip of my code camp presentation on Service Broker. Also, some of the links ar eto blogs...

Well, let's start with the basics: is your Import process slow because it is CPU-bound or because it is IO-bound? If it is CPU-bound, then all the partitioning...

What is the maximum number of Quantity's per QuoteNumber?

I think that there might be some confusion here between two very different things.

As far as I know, Notification Services (NS), is a message distribution facility in SQL server 2005...

Answered at that thread.

The modified date is not the last time a Table was UPDATEd, but rather the last time that is was ALTERed.

Thanks for the feedback.

I have not used DMO, but it is was SQL server 2000 Enterprise Manager uses and it does appear somewhat similar in approach to SMO.