1173
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
■ (^) Expression Task: Provides a way to add a value into the package using an expres-
sion that is always evaluated at run time.
■ (^) File System Task: Provides a number of fi le (copy, delete, move, rename, and set
attributes) and folder (copy, create, delete, delete content, and move) operations.
Source and destination fi les/folders can be specifi ed by either a File connection
manager or a string variable that contains the path.
■ (^) FTP: Supports a commonly used subset of FTP functionality, including send/
receive/delete fi les and create/remove directories.
■ (^) Message Queue: Sends or receives queued messages via MSMQ. Specify the message
connection, send or receive, and the message type.
■ (^) Script: This task enables either Visual Basic 2010 or Visual C# 2010 code to be
embedded in a task. Properties include the following:
■ (^) ScriptLanguage: Choose which language to use to create the task.
■ ReadOnlyVsariables/ReadWriteVariables: List the read and read/write variables to
be accessed within the script, separated by commas, in these properties. Entries are
case-sensitive, so myvar and MyVar are considered different variables.
■ (^) EntryPoint: Name of the class that contains the entry point for the script. There is
normally no reason to change the default name.
See “Coding and Debugging the Script Task , Interacting with the Package in the Script Task” at
http://msdn.microsoft.com/en-us/library/ms135952(v=sql.110).aspx in SQL
Server 2012 Books Online for additional details.
■ (^) Send Mail: Sends a text-only SMTP e-mail message. Specify the SMTP confi guration
manager and all the normal e-mail fi elds (To, From, and so on). Separate multiple
addresses by commas (not semicolons).
■ (^) Transfer Database Objects Tasks: All use SMO Connection Managers.
■ (^) Transfer Database: Copies or moves an entire database between SQL Server
instances
■ (^) Transfer Error Messages: Transfers custom error messages (via sp_
addmessage) from one server to another
■ (^) Transfer Jobs: Copies SQL Agent jobs from one SQL Server instance to another
■ (^) Transfer Logins: Copies logins from one SQL Server instance to another
■ (^) Transfer Master Stored Procedures: Copies any custom stored procedures from
the master database on one server to the master database on another server
■ (^) Transfer Objects: Copies any database-level object from one SQL Server instance
to another
■ (^) Web Service: Executes a web service call, storing the output in either a fi le or a
variable.
c52.indd 1173c52.indd 1173 7/31/2012 10:29:28 AM7/31/2012 10:29:28 AM
http://www.it-ebooks.info