People are going to lynch me for this first question, but...

When was the last time you rebooted the box?

Has SQL Server Agent run before on this box or is...

I don't know if it's the reason for this particular error message, but you do need .Net framework before you install SQL Server. In fact, you need several components for...

Remember that connections are different from threads. One connection can spawn many threads.

Which is it you're trying to control? Connections or threads?

kajf (10/20/2010)

---

Below query gives me all straight relations (have not created a BundleID but in this easy case I can set an unique BID per A) .

...

Result:

A3C3

A4C4

A4C5

Is it a good...

Kaj,

Here's why no one's responded yet. Your question breaks down at this point.

kajf (10/20/2010)

---

I have a table AC containing two attributes A and C which have a many-many relationship. What...

Do us a favor? When posting your DDL statements, remember to put quotes around string values that are to be inserted. It makes it easier on us when we don't...

chris.stuart (10/21/2010)

---

When I say manually, I love editing the packages outside of BIDS, and in 2008 it works much better (manual edit of the package) where as in 2005 I...

RICHTER-311234 (10/20/2010)

---

I have rebuilt the index and ran a updatestats full on the index I am wanting both queries to use, Just a bit at a loss as to what...

Could you please post your table structure and some sample data so we could verify the advice we're giving you before we give it? It's hard to help you when...

There are several ways to split strings in addition to the method Chris mentioned. Google "SQL Server Split Strings," choose one that seems to work, and apply that methodology to...

chris.stuart (10/21/2010)

---

When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", you...

Boys,...

irobertson (10/20/2010)

---

Hi Bill,

One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.

Also,...

I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.

I'm a little confused. What exactly are you trying to map?

Are you just trying to show the "guts" of a SSIS package? Or is this something else?