DTS Package connection

[theprogrammer]

I am developing some DTS packages to import data into a database where the connections require a VPN connection to be up. If I am disconnected from my VPN, I get an error when I attempt to edit the query for coping the data. The error is a time-out error on attempting to connect. Of course, if my VPN is up, I do not have this problem, but I want to be able to make changes without the VPN up. Anyone have any idea how I can do that?

 

[JohnDTampaBay]

Disconnected Edit (from the Package menu) should allow you to drill down to data pump, double-click the SourceSQLStatement property, and update the query as you like. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)