100 likes | 186 Views
Where to Put Your Package. Okay, stop giggling – this is SQL Server!. About Me. SQL Server DBA since 2006 Data professional for a small non-profit Spend a lot of time considering how things fit together Blog: http://www.MrAndrewDykstra.com Twitter: @ MrAndrewDykstra. The Data Flow Task.
E N D
Where to Put Your Package Okay, stop giggling – this is SQL Server!
About Me • SQL Server DBA since 2006 • Data professional for a small non-profit • Spend a lot of time considering how things fit together Blog: http://www.MrAndrewDykstra.com Twitter: @MrAndrewDykstra
The Data Flow Task • Storage Options • Security • Backups • Package Execution
Where do you store your SSIS packages? (SQL2k8 - msdb.dbo.sysssispackage)
Security - File System Windows Security
Security - MSDB Access to MSDB + SQL Server DTS Roles: • db_dtsadmin (and sysadmin) • SELECT *, INSERT, UPDATE *, DELETE *, EXECUTE *, EXPORT *, GRANT|REVOKE * • db_dtsltuser • SELECT *, INSERT, UPDATE <own>, DELETE <own>, EXECUTE <own>, EXPORT <own> • db_dtsoperator • SELECT *, EXECUTE *, EXPORT *
Backups FILE SYSTEM • File System Backups • Windows backups, copy to thumb drive, upload to the cloud, etc. • File System Restores • Just restoring a file from one media to another MSDB • Backing up system databases • specifically the msdb database • Restore MSDB
Execution FILE SYSTEM • Command Line (dtexec) • GUI (dtexecui.exe or SSMS) • SQL Agent Job MSDB • GUI (dtexecui.exe or SSMS) • SQL Agent Job
This Stuff Isn’t New But sometimes it just helps to go over it again… • Storage • Security • Backups • Execution
Please Review • Speaker Rate.com • SpeakerRate.com/MrAndrewDykstra • Blog • MrAndrewDykstra.com/2010/10/Where-To-Put-Your-Package • User Group Website • SpringsSQL.SQLPass.org/Resources.aspx