Thats absolutely correct but i am not able to get the tns entry correct just with the details i have. it shows error msg as ORA-12514: TNS: Listener does not...

Thanks for the response. i just learnt the migration is from oracle to oracle only using SSIS> bit strange but thats how the client prefers. Now i am trying to...

Anything other than sql profiler trace/performance monitor as i suppose they do put some load on the server when running. Also just making sure will running a sql trace have...

I fully understand that using nocheck or ignore_dup_key clause wont help in creating a unique index/constraint. Just that i dont want to delete the existing data but want to make...

Tried adding the ignore_dup_key clause also as in index below but somehow it errors out saying

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the...

The xml data looks something like this

data id="AGE_CAT"AGE-30/data data id="BMI_CATEGORY"data id="HEIGHT"

instead of 30 is the age column in table is updated to 35 the xml column should reflect this change.

somehow xml data doesnt show up to clarify the questions. its something like

xml =

Running an update directly on xml column wont help as its a concatenation of age, dob, firstname, lname and many other columns. something like

if age = 35

xml = ........(how...

Thanks Ken. you are right if i exclude thsi part of the sql

OR (T.Id1 = 0 AND T.Id2 = 0 AND T.Id3 = 0)

i get the data as

1 A B 2000-01-01 00:00:00.000 ABC 999999999 0 0

3 A B 2005-01-01 00:00:00.000 ABC 888888888 0 0

5 A B 2004-01-01...

Thank so much Ken for your sql. Its gets me 1 existance of every record where either id1,id or id3 exists. howevere for a records as this

3 A B 2005-01-01 00:00:00.000 ABC 888888888...

But unfortunately that gives my multiple records or am i doing something wrong

select a.fname, a.lname, a.dob, a.batch,a.id1, a.id2, a.id3

from table1 a, table1 b where ( a.fname = b.fname and a.lname...

Sorry forgot to add this to the original post..

For the 2nd part dynamic sqls can be easily eliminated but is there an easy way to eliminate in 1st update ....

Soon as the external drive is plugged into the server wont it show up a local drive on that m/c or does anything need to be set up see this...

On the server where i am trying to do the restore , both sql server and sql server agent the logon is "Local System Account". Not quite sure what you...

Great, that worked really work. I would also like to know how can i autoincrement a column if its not an identity column. Since everytime the table inserts fresh data...