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?

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



[quoted text, click to view]