Ah! I see. Just to make sure I was going to give you good info, I went
into enterprise manager and viola, there is no import, file - open, or
anything... Good thing I checked. The key issue for you is that your
lab, and rightfully so, is cut off from everything else. I've always
used the Save As... and just saved it to another server. However, this
won't work for you. I've just looked around and I don't see where you
can import or even generate sql scripts for your package. I'm no guru,
but if you can do this, you would think it would be somewhat intuitive.
I'll keep looking and let you know if I find anything. Good Luck.
Mark
-----Original Message-----
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Its a very unique situation. We have a training lab here that is
completely
cut off from the outside world. One of our clients is coming in to train
on
our applications. Al of their data is on our live DB, but I need to be
able
to save something to disk to carry over to the training server and
import
it. I have already saved a .dts file of the db and now I can't figure
out
how to import it.
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
-----Original Message-----
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:08 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Tim,
Need a little more detail here. Where do you want to import from/to? Is
it safe to say that you've created a DTS package on, let's say, a dev db
server and you now want to export it to your production db server?
Mark
-----Original Message-----
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:03 AM
To: CF-Talk
Subject: OT: Importing saved DTS in SQL 7
Hey,
How do I go about importing a saved DTS once I have it?
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
