I change default data directory and default log directory
in SQL Server settings to C:\DB_Data\. When I'm creating
new DB it's creating everything fine in folder
C:\DB_Data\, but if I'm doing DTS with creating new DB on
source server then it's creating data file and log file
back in C:\Program Files\Microsoft SQL
Server\MSSQL$SERVER06\Data\ folder.

How I can set default folder for DTS new DB?

Alex.

The default directory is set for the server itself.

To stop this happening then make sure you say similar to : (Taken from BOL)

USE master
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO


--

----------------------------
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



"Alex Rybalov" <alex (AT) covers (DOT) com> wrote

One very quick way around this is to use an EXECUTESQL task and do your
create in there. You can then simply repoint the connection's Catalog
property to the new DB.
Why not create the DB outside of DTS ?


--

----------------------------
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



"Alex Rybalov" <alex (AT) covers (DOT) com> wrote

I can create DB outside DTS, and usualy I'm creating
script from old DB, chancing paths (if necessary) and
creating DB from this script, and then doing DTS.
Yesterday I desided to make it without script... Hehe...

For me this is look's like a bug...