Package Seen More than Actually Present

#1

I have a problem

Package is stored in msdb database.But I was surprised to
see many package in the database table sysdtspackage.
How is this possible.
Would it have some effect in my website if I am using this
package there.

Is there any way through Which I can Stop such recreation.

Thanking in advance to whoever comes forward to help me
out.

#2

These are the versions of the package. When you "Save" the package you are
entering a new row in the table

--

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

"Aneesh" <aneeshgk (AT) yahoo (DOT) com> wrote

Quote:

I have a problem

Package is stored in msdb database.But I was surprised to
see many package in the database table sysdtspackage.
How is this possible.
Would it have some effect in my website if I am using this
package there.

Is there any way through Which I can Stop such recreation.

Thanking in advance to whoever comes forward to help me
out.

#3

In article <#c71wGlQDHA.3880 (AT) tk2msftngp13 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes

Quote:

These are the versions of the package. When you "Save" the package you are
entering a new row in the table

--

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

"Aneesh" <aneeshgk (AT) yahoo (DOT) com> wrote in message
news:021801c34250$d19e3850$a101280a (AT) phx (DOT) gbl...
I have a problem

Package is stored in msdb database.But I was surprised to
see many package in the database table sysdtspackage.
How is this possible.
Would it have some effect in my website if I am using this
package there.

Is there any way through Which I can Stop such recreation.

Thanking in advance to whoever comes forward to help me
out.

.... and you cannot stop this happening, as saving the package generates

a new version (row). You can delete old rows or versions either through
the object model or directly in T-SQL.

There is no real performance drop if you have lots of versions, unless
you had millions of course, but storage may be high.

I just clean-up every now and then.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Package Seen More than Actually Present

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Package Seen More than Actually Present - 07-04-2003 , 12:22 PM

Re: Package Seen More than Actually Present - 07-04-2003 , 12:28 PM

Re: Package Seen More than Actually Present - 07-05-2003 , 03:42 AM