Wow, that is obscure.. Good to know though..

CEWII

My first glance would seem to indicate that looks just fine.

Have you verified that the task that fills the object variable is set to full result set? And the...

Koen Verbeeck (2/24/2012)

Second that one. The File System...

It is not mandatory for clustering, just highly recommended. I have a dev cluster with a single nic, not ideal but a limitation that I don't have any choices...

Are you absolutely sure the datatype is exactly the same?

CEWII

Jarid,

SSIS is a wide and varied topic. For examples of Script Task (a lot), ForEach Loop Task, Sequence Container, Data-Flow Task, WMI Reader Task, and I'm sure others I...

Actually that is really straightforward. Based on these assumptions:

1. You have one DB connection for the source (regardless of the number of tables at that source).

2. You have a flat-file...

You might map index 2 to something. I seem to remember this problem but can't remember how I fixed it. I believe it was tied to trying to...

I hadn't read the last mesage and was thinking firewall.. Good deal, so it works as expected. I do say that the mode you are running in is...

I often look at the query plan to see what indexes it is using and if they make sense..

CEWII

Ok, as I read that you have a default instance and a named instance. And that looks fine to me. I have two as well but am only showing...

Without the Browser service the named instance is unlikely to connect.

Your cluster manager should look something like this:

CEWII

Is the SQL Browser running?

CEWII

What is the mode you are using? Node Majority?

How many nodes are up?

Do the SQL Services show as running?

CEWII

Isn't that what I said? 😛

CEWII