I did google it but I wanted to see if there were good references that someone here knew about...
Thanks for the help. Howie --- On Monday, May 23, 2005 10:12 AM, Dawson, Michael scribed: --- > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:158372 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
