In the past my SQL server sat physically next to our IBM iSeries,I transfer the data from the DB2 over to my SQL's and of course we had no problem executing the SSIS's because unless the switch between the two went down the connection was consistent.
Recently, we had to move our iSeries to California to our parent company location, which works as long as the PNT that connects us stays up.
What can I do to verify the connection is up between us and them before the packages execute? I have about 40 SSIS's running nightly,
some of them completely truncate tables and then completely reloads all the data. If the lines drop then my tables are blank.
Should I first ping the location then execute?
Any suggestions I would appreciate - thx
Start Free Trial
