The first thing I would do is see if your network people can make the network connection as simple as possible. You might be able to get away with creating a linked server if the VPN is configured to allow the necessary traffic.
Then, look at www.sqlservercentral.com for some good references. There is also another site dedicated to DTS, but I can't think of the name right off. Google it. When I create my packages that connect to a different system (AS400/mainframe), I always throw a step in to "test" the connection before I delete any local records before refreshing data. If I can't do a simple query against a remote table, I end the package and send an email message. M!ke -----Original Message----- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 9:01 AM To: CF-Community Subject: DTS coding I have a potential project that requires transforming one database schema into another. The project specifies using DTS. Does anyone have an online resource for this or could someone give me an idea of how easy or difficult this would be to code? The project calls for one MSSQL server to DTS data via VPN from another SQL server. Thanks, Howie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:158370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
