Hi All!

What are cons and pros between DTS packages stored in SQLServer vs.
Structured Storage File

Can a package stored as Structured Storage File be edited in
Enterprise Manager? How can it be opened?

Thank you in advance

How do I open a file package or template
(http://www.sqldts.com/default.aspx?289)

The package object is exactly the same, it is just what you prefer for
storage locations. Do you like using VSS for example to hold files or would
you prefer to manage it in a DB, and have the option of moving between DBs
rather than files.

The choice is yours.


--
Darren Green
http://www.sqldts.com
"Andy" <net__space (AT) hotmail (DOT) com> wrote

"Andy" <net__space (AT) hotmail (DOT) com> wrote

to move a package to another server. Once a package is ready for production
I save it in the server before setting up a schedule to run it. In short:
file for development, server for production.
Jack Peacock

"Jack Peacock" <peacock (AT) simconv (DOT) com> wrote

Does it create overhead for SQL Server when a package stored in the server runs?

"Andy" <net__space (AT) hotmail (DOT) com> wrote

(limitations on remote server thruput) so the CPU usage is fairly low
anyway. There can be problems with having the right user profile when the
job runs. If I use a DTS package that depends on mapped drives I run it as
a file, Scheduled Task with DTSRUN, to make sure the user and shares are set
up right.
Jack Peacock

In message <edb90340.0411170758.6b8d7fe1 (AT) posting (DOT) google.com>, Andy
<net__space (AT) hotmail (DOT) com> writes
The overhead is a single call, which basically is a SELECT MyPackageData
FROM sysdtspackages where package = mypkg, so no.

The overhead comes on the machine which executes the package and any
machines used as sources and destinations, which will be exactly the
same regardless of the storage location.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org