Hi, I just need to know if there's a way I can edit an
existing DTS package. The package I'm dealing with right
now has been written with a D partition in mind and I just
need it to point to C. I've got the full version of SQL
server 7 running.
If I can make that change then I could easily re-run the
DTS package involved manually.
The situation is that I'm working for a small POS company
that's migrated their repository from MS Access to a MSDE
backbone.
One of the steps involved in this migration happens to
involve running a lot of DTS packages and all but one of
them is pointing to a D drive. Probably due to the fact
that we were using NT4 SP6 (**shudder**) and we've now
moved to 2000 (pretty good OS).

If you could e-mail me direct, I'd appreciate it.
Otherwise, I'll just check here regularly.

Thanks.

Yours Truly,

Ka Kwok

What in particular has been written with a D partition in mind.?
Is it a task within the package ?
Is it the location of msdb?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Whoops, my bad.
The source database. The package was written to look for
the source database in a D partition, however on our new
systems, we've upgraded them to Win 2000 thus removing the
need to parition the hard drive (strictly speaking, we
should still do it for security reasons).
Anyway, our suppliers hadn't informed us if this little
glitch till it was after the fact.
I've been able to buy time and convince them that's not a
major problem, but they're not going to buy that forever.
I'm just hunting around MS SQL7 just to see if there's a
way I can just unpack the DTS, repack it and then run it
through a command line on site at the clients.

Thanks.

Yours truly,

Ka Kwok

In article <305f01c379f7$8fd06c70$a601280a (AT) phx (DOT) gbl>, Ka Khiong Kwok
wrote:

OK this begs the question of why are you looking for a database on a
particular drive? A database is a database and the SQL Server
connection looks for it regardless of where it is on the filesystem.
To mount a database to a different drive than it was previously in your
RESTORE statement you can use WITH MOVE.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org