It's been a while since I did this, but I think you have to connect to the old IP if you still can, open the project, then change the database connection configuration to the new IP. If you can no longer connect to the old IP, there may be a way to manually edit the config file outside of VS. I'll see if I can find my notes from when I dealt with this problem, but you might get an answer quicker from Microsoft or the DEVNET forums.
Good luck. On Fri, Aug 8, 2008 at 9:00 PM, Mike Kear <[EMAIL PROTECTED]> wrote: > I'm using MS Visual Studio to build a SSIS package to upload my database to > the remote server. The database has 39 tables with quite a complex array > of foreign keys and dependencies, so they can't be just uploaded. They > have to be uploaded in the correct sequence or the upload failes. > > We've moved our database to a new Ip address, so I need to change the > connection manager to point to the new location. > > The trouble is, when I open the project in Visual Studio, it tries to > validate everything and can't because the server it's trying to connect to > is gone. So it hangs and that's the end of my work on that today. > > How can I redirect this project to the new IP address, without it hanging > like this? Can I open the project without it validating so I can change the > connection setting? I'd much rather change the existing one rather than > have to build the project again from the beginning. That was a LOT of work > to get it all uploading in the correct sequence. > > Cheers > Mike Kear > Windsor, NSW, Australia > 0422 985 585 > Adobe Certified Advanced ColdFusion Developer > AFP Webworks Pty Ltd > http://afpwebworks.com > Full Scale ColdFusion hosting from A$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3124 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
