Error in DTS package - URGENT!!!!!!!!!!!!!!
-
Hi, I have created a dts package. all the values like Source Data connection, source userid and source pwd is passed through variables and for destination database all these values are hardcoded. At design time I used a DSN which points to SourceServer1. Using this DSN it stores mapping between source and destination at design time. After this I executed this pakage with the same DSN it worked perfectly but when I changed datasource of the destination from SourceSrver1 to SourceServer2, I am geeting error "SourceServer2 is not same as the SourceServer1". When I am passing all the connection info using global variables then why it is looking for the connection info that I provided at design time? It's very urgent, any help is deeply appretiated. Thanks in Advance.
CodeManiac xxxxxxxxxx xxxxxxxxxx