just confirmed with the network team that the local windows firewalls are not on and that there are no firewalls turned on between the 2 servers working together over the...

no dice..network dtc access is on, allow inbound / outbound is on w/ mutual authentication..enable XA is on and the DTC logon uses network service..

the os's are similar in that...

yes, i havent had any issues querying other servers. you think its a ms dtc setting?

i've also encountered this problem. my solution was to check to see if there was an open connection to the program that the BAT file was calling.

for example, my...

so does the method of import really not matter or was that just a coincidence?

thanks for the replies - extremely helpful

-- to answer your question on why i took...

AscT1AscT2CheckSumT1CheckSumT2numbert1chart2char

83831601601SS

1091091541542mm

97971421423aa

1081081531534ll

1081081531535ll

3232006

71711481487GG

1141141591598rr

1111111561569oo

11711716216210uu

11211215715711pp

[font="Arial Black"]103210012 [/font]

4040404013((

898916616614YY

4747474715//

787815515516NN

4141414117))

i did try various methods of importing and T-sql, still all different. after trying the char to char script, here are my results:

select checksum(t1char),checksum(t2char), t1.number, t1char, t2char

from

...

i typically would use a SAN unit and RAID 5 for the MDF

HI,

the value that i want to replace doesn't matter, its only the position. for this example i need to replace position 15, perhaps next week i will need to...

Lynn Pettis, you get a gold star.

this worked perfectly.

thanks for everyones input...it was an interesting topic.

i failed to make my ID's 1,2,3,5 in my example...but this query would fail if the ID's are not in order

actually this doesnt work!

i had tried a similar solution, however i worry about the ID's not being in succession. In my example, the ID's are 1,2,3,5.

awesome

this worked..

thanks!

Paul Mu,

Your solution works best for me. Thanks for everyone's input!

Ryan

Nope, the upc is always last. And its always a number with no spaces.