Receiving Data File Messages

Data Transformation Services

Data Transformation Services

Receiving Data File Messages

Use data file messages to transfer data files from computer to computer. A data file message contains a Data Transformation Services (DTS) package ID, a version ID, and the name and contents of a data file.

On receipt of an acceptable message, the transmitted data file is saved and the Message Queue task terminates successfully. If no acceptable message is initially on the queue, the Message Queue task waits until one arrives. If the specified timeout interval expires first, the task fails.

You can save the transmitted data file to a file or a directory location. If the save path specifies an existing file, you need to overwrite the file or the step fails.

Important  Any change in the package sending the data file message will result in a new version ID. If you click Filter by version on the Message Queue Task Properties dialog box, messages from the modified package are ignored.

To receive a data file message with the Message Queue Task