The packages will be most portable when you save then as a structured storage file.
A DTS package BTW will use the server it's executed from. I have some DTS packages which I successfully move from server to server, never changing a thing, they are all Structured Storage Files though. PS. Use DTSrunui to create the execute string (its easier ;-)) Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Ryan Sabir > Sent: Tuesday, 2 March 2004 5:44 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: OT:DTS shenanigans > > > Hey there, > > By manually update, do you mean to use "Disconnected Edit" ? > > We're also having problems getting the job to run on the > server. It works fine in our development environment but when > we transfer the DTS package to the server it starts > complaining about not finding the server. We've tried going > in and updating all the references from the dev server to the > live server, but still not working. > > Is there a problem with the way we are writing the DTS tasks? > Is there some way to set up our environment so packages will > transfer easily between servers? > > thanks for any help, bye! > > > > Tuesday, March 2, 2004, 5:18:44 PM, you wrote: > > ER> Hi Ryan, > > ER> how is the DTS package going to be invoked - via a sql > server job? > ER> Use a local copy of the text file to setup the import > profile, then > ER> manually update the file path to the correct path for the sql > ER> server. > > > ----------------------- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
