Chris,
I guess I didn't look thoroughly enough. You are exactly right! Although
I'm using SQL Server 2K, the process is the same except it says "Open
Template" instead of Open Package. I have learned something today, I can
go home now... Thanks!
Mark
-----Original Message-----
From: Chris Sinkwitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 11:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Step 1.
Go into Enterprise Manager
Step 2.
Connect to your database server
Step 3.
Right click on the Data Transformation Services folder
Step 4.
Select All Tasks then select Open Package
Step 5.
Browse to your floppy or where you put the .dts package and open it.
Step 6. If you want to reuse it just save again once it is open to the
SQL
Server Repository.
If you have anymore questions let me know.
Chris Sinkwitz
-----Original Message-----
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 7:41 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
