Nisal's Business Intelligence Blog

Learn, Grow and Share on Microsoft BI & Analytics Platform

Tweets

LightBlog

Thursday, February 25, 2016

Issue Fixed: [SSIS.Pipeline] Error: "OLE DB Destination" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

Sometimes when you are working on SQL Server Data Tools - SSIS development Studio you might get following error.

[SSIS.Pipeline] Error: "OLE DB Destination" failed validation and returned validation status "VS_NEEDSNEWMETADATA".


Resolution: Even though you close your solution and re-start the SQL Server Data Tools development environment this issue will be exists. The immediate solution is just delete the OLE DB destination component and add it again from SSIS tool box and create the mappings. After you create New OLE DB destination component all the metadata will be updated with latest schema changes.


Most possible reason for this issue is while you opened your SQL Server Data Tools you probably have changed metadata on a table referred by the OLE DB component.

Note: There may be other solutions which could solve the problem. But, this method will be quick solution in-order to get rid of the issue.

Cheers !..

No comments:

Post a Comment