Hi,

I am very new to DTS. Actually i have data in various
views on sql server 2000. I have to perform some queries
on these views and trasfer result data to Excel sheets,
and i also need to schedule this job. I felt the best way
and the safest way is DTS.

1. Can I use DTS and write the SQL Query using views or
do we need to only make use of Tables??

2. Can we execute complicated queries in DTS like the
queries which have multiple Join Statements e.g may be 10-
15 Joins. I am making use of 10-15 views and writing my
query. Can i execute this query in DTS ??

Any help would be greatly appreciated.

Thanks,
Abhiram

Views are good
I would wrap the complicated statements in views but yes it is possible

--

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


"Abhiram" <anonymous (AT) discussions (DOT) microsoft.com> wrote