Recently our PC and IBM AS/400 server have move to another building. The IP address of both pc and AS/400 have been changed. I assume I need not to change anything in MS SQL DTS package when extract data.
I experience problem when i executing DTS to load data into a table. The DTS perform task to load data using different system DSN. For example It work fine when I load data into Table no. 1 to table 5 (using system DSN XXXX). but when I load data into Table no. 6 which required different system DSN (Example YYYY), it keep on running non stop, even the task usually only take 10 minutes time. No error message.
Are there any option that need to be set in order to execute the package?