Alright, all good information, so instead of the IS NOT NULL is is effectively UserId = 12345.

How many rows of notes are there?

If you already know the UserId...

SQLWannabe (6/15/2010)

---

I respect all of your views about keys, indexes and the like. It's great to hear different views on the same topics and let my mind try to wrap...

I was able to reproduce when database compatibility level was set to 80..

I don't think it is a SQL version difference as much as DB compatibility difference.

CEWII

I don't think this is doing what you think it is doing..

COALESCE by defiition in SQL BOL:

Returns the first nonnull expression among its arguments.

It is used like COALESCE( Field1, Field2,...

Although without testing it I can't quantify it, I think the first would perform better, my rationale is that it should be a fairly simple math operation where only the...

I'm going to go out on a limb and say that you have usernames/passwords in a connection string? If so then the package can ONLY run successfully as you....

You are very welcome.

CEWII

That clarifies things for me, thank you. A fair number of these questions are based on misunderstandings or poorly written business requirements. and no understanding of the ramifications.

So...

You might take a look at this link to start http://www.codeproject.com/KB/database/foreachadossis.aspx

CEWII

There is no need to do this, the OLE DB command only uses the columns that you map into it, so if you have 100 columns but only need one...

I've done it with all of the above, the most common was the SCD out of the box. But I have done it manually with T-SQL, and I have...

David Korb (6/15/2010)

---

There appear to be 5: C,D,F,G, &...

Without third-party tools a backup only encryption is difficult. However, you can use Transparent data encryption (TDE), what I am unsure of is what versions TDE is available in,...

David Korb (6/14/2010)

---

Elliott Whitlow (6/14/2010)

---

32 or 64-bit?

Local drives or SAN?

RAID array? What raid level?

Are the OS drives on seperate disks from the SQL data files?

Are the database log files...

Out of the box SSIS will not do this there is a company called CozyRoc that I *think* has a third-party component that does this. You could also use a...