Data Loading from Cluster Server Environment

[sanketkhunte]

Hi All,

My Source is SQL server : In which has Clustering structure. (Let say - for production we have 3 servers).

Let's define their names as below

Prod 1

Prod 2

Prod 3

I am trying to pull data from Production boxes;It Started reloading and after some time it throws ODBC Error.

(I tried it 2-3 times but could see same error)

What will be the problem.

Please provide your input on this. 

Sanket

[#2]

Maybe you can do a few things:

• Look at the log files and see which sever pull is causing the issue
• You would be having three separate connection strings for each of the servers right? So go through doc log and see also which table is causing this issue
• Once you find out which server/table is causing this try some other table with that same server and see what happens
• The log file should be very useful in this situation

Thanks

AJ

[#3]

If you are in the domain, why not use OLE DB?

here is an example:

All you have to do is select your server name, use Windows NT, and select your database.  Also, test your connection then click OK.

Robert