[dba-SQLServer] SQL Agent Jobs

When stored inside the database SSIS packages will reside in
msdb.dbo.sysdtspackages90 in the column Packagedata.
You can run SSIS packages in a SQL Server Agent Job whether the packages
resides externally or in the msdb database.
I think the main advantage storing in msdb is backup. If you make regular
backups of msdb you can recover all your SSIS packages.
The main con for storing in msdb could be when you update/make changes to
the packages - then you have to redeploy the packages to msdb, but that's
not a big issue I think.

Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur
Fuller
Sendt: 9. juli 2008 15:49
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] SQL Agent Jobs

Thanks, Asger.

On a related subject, what are the pros and cons between storing SSIS
packages inside the database vs. externally? Any thoughts on that subject?

Arthur

On 7/9/08, Asger Blond <ab-mi at post3.tele.dk> wrote:
>
> msdb
>
> Asger
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com