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:3123 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
