Hello,

Is it possible to create a DTS package through simple SQL source in Query
Analyzer?

We create a new project every month and I run an .sql file I create in Query
Analyzer which creates stored procedures, views and imports tables in to the
new database from the previous month. I set up some simple variables at the
top and the procedures are created for the new month.

I then create a DTS package (using DTS Wizard) that exports 5 of the tables
in the database to an Access file on a drive and schedules the package to
execute at 5am every day.

I'd like to be able to do the same for the DTS package I have to create
every month. I have to do this for 10 projects every month and I'm just
looking for a more efficient way.

Thank you,
Mike

Without knowing an awful lot more about what you are saying

1. You do not want to build DTS packages in TSQL believe me !
2. You do want to take a look at www.SQLDTS.com and have a look at how we
parameterise things like connections, statements and the like.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Mike Barbone" <mikeb (AT) besatisfied (DOT) com> wrote