I have a few DTS packages all using Active X scripts in them. The differences between them on each server is the connection strings. Some I use myconn.open and other I use mydestconn.open at the beginning of the connection string. However when I use 'mydestconn.open' the compare tool highlights this as the change, not the server name(which is the change). If I use 'myconn.open' it works just fine. Not sure why this is.
0 · Share on Twitter
This discussion has been closed.