Using Data File Messages to Collect Data
The Load Expenses package uses a data file message to take a spreadsheet from a queue, extract expense data, and load it into a database.
Your traveling sales force uses a standard Microsoft® Excel template to enter expenses on their laptops. Every week, a Data Transformation Services (DTS) package on the laptop sends the completed worksheet in a data file message addressed to a queue at corporate. When the laptop synchs with the network, the message is delivered. The Load Expenses package processes these messages on arrival.
Follow these steps to create this package on your computer.
Creating and Configuring the Load Expenses Package
The new package must be created and named. In addition, package properties must be set so that a single failure does not shut down the service.
To create and configure the Load Expenses package