The Script Task has
the full power of the .NET framework and is very powerful. It can combine several
tasks by few lines of code very easily increasing the productivity. For example,
the last script example would have required a Data Flow task with DataReader
Source and its connection manager, a File System Task, and a file system connection
manager, a precedence constraint, etc. While Script Task can do a lot of heavy lifting,
its interface to COM objects is not straightforward as SSIS does not support COM
for this task, a real impediment to productivity. The interface for the Script Task is
not completely described in this chapter, with emphasis placed on hands-on activity;
the reader must acquaint himself/herself with the complete details of the Microsoft
Visual Studio application to derive the full benefit.
Package with Maintenance
Plan Tasks
Database maintenance tasks have been designed to take care of tasks that are needed
to maintain a database by keeping it up-to-date and consist of many activities that
are needed to be performed either on demand or follow a set schedule. Three items
have to be considered for database maintenance:
Optimizations
Integrity
Backups
These tasks can also be managed from the Microsoft SQL Server Management
Studio, as seen using the wizard by making a right-click on the Management Plans
node in the Management Studio. As you can see, the wizard can be configured to
carry out several tasks listed on its opening page.
Pages:
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200