Dear All,

I am new in using the DTS and is learning by reading
the "MS SQL Server 2000 DTS SBS." While I am impressed
with the DTS Designer in creating a new package, I am
wondering when do I need to save a package and re-execute
it gain? Similar to running a VB,ASP,or JSP script?

Up to now, my responsibility seems to need to run those
Conection and Tasks once to creat and/or populate the
tables, or one by one while evaluaing the data files and
table schemas. In which applications or DBA operations I
need to save those connections and tasks as a package, and
excute it again and again?

Thanks,
Jeffrey

This is your call.

Is the package you just created a one off or do you intend using it again?

If you want to use it again then save it calling it a name which means
somethign to you and others and also describes what that package does.
You can, and I would, either save it to a structured storage file or to a
sql server.

Once you have done this then you will see it either appear in the file
system or in the "local Packages" section of the SQL Server (The one to
which you chose to save it.)

To open a package from the file system then you can

right click on the DTS folder in EM | Open Package | Navigate to your .dts
file.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Jeffrey" <jwang (AT) dot (DOT) state.tx.us> wrote

Allan,

Thanks. Can you give me some examples when I may need to
save the package and run it again?

TIA
Jeffrey

So you may have a package that say

Takes deltas from your source table and inserts it into a new table.
Takes data from a source, performs some complex transformations thereon and
decides if it wants to insert it into a destination
Loading a Data Warehouse.


There are loads more as well.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Jeffrey" <jwang (AT) dot (DOT) state.tx.us> wrote