The Dummy Destination component works as a sink for SSIS data flow pipeline by receiving incoming rows like a typical destination component, but it does not perform any actual writing. When it is used in a data flow task, it will make sure that the data flow will be processed during runtime even when the Runtime Optimization has been turned on.

With the Dummy Destination component, developers can prevent the data flow task from reporting any warning messages regarding unused columns from upstream components.

The Dummy Destination component, part of the SSIS Productivity Pack, support files stored locally or in the cloud.

SSIS Dummy Destination Component

Dummy Destination component is available in our SSIS Productivity Pack

Data integration made easy

This component is a free component that requires no commercial license, or any specific configurations. Neither will it ever perform any meaningful write operations. If it is desired to have the data saved, it is advised that you could use one of the other destination components, such as the Premium Flat File destination, Premium ADO.NET destination components, etc.

Other components are available within our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions for enterprise applications including Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.