My dts package takes Oracle data from Server A and puts it into SQL Server on Server B. Previously, it worked great. Then, we bought a new Oracle Server. The new Server has the same name on the network, but it has a different IP. Now my DTS package does not work.
In my dts package, there is an icon that looks like a set of building blocks. Most of the blocks are white but one is purple. I think that this object is my connection to Oracle. One of its properties is "Locale Identifier". That property is a four-digit integer that I don't recognize. My gut feeling is that that somehow tells dts where to find Oracle. Maybe it maps to an ip address.
Here are my questions:
1) Am I correct? Does the "locale identifier" tell dts which server to use?
2) If I'm correct, how do I determine what number to input? This is a mystery to me, because as I say the existing entry is not an ip. I need to go to my network guru and say "what is the foo number for the new server?" But I don't know what foo is.
In my dts package, there is an icon that looks like a set of building blocks. Most of the blocks are white but one is purple. I think that this object is my connection to Oracle. One of its properties is "Locale Identifier". That property is a four-digit integer that I don't recognize. My gut feeling is that that somehow tells dts where to find Oracle. Maybe it maps to an ip address.
Here are my questions:
1) Am I correct? Does the "locale identifier" tell dts which server to use?
2) If I'm correct, how do I determine what number to input? This is a mystery to me, because as I say the existing entry is not an ip. I need to go to my network guru and say "what is the foo number for the new server?" But I don't know what foo is.