Solved

SSIS procedure returns error message

Posted on 2014-10-08
2
152 Views
Last Modified: 2016-02-11
When I run a particular SSIS procedure I get the following message...
External column NextCertificationDate needs to be removed from the external columns. VS_NeedsNewMetaData. Can someone tell me how to go about getting to the external columns. The problem is obvious via the error message. But I am not sure how to get to the External columns that are mentioned. I am clueless about the reference to VS_NeedsNewMetaData. How do I refernce this?

Thanks in advance
0
Comment
Question by:tesla764
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40368312
In whatever data flow this is errorring in, delete the precedence constraints (aka green-blue-red arrows) that go from source to destination, and then map them.  

The likely problem is that either the source or the target was edited to remove this column, and it's still being mapped.  

SSIS is notorious for any minor change in a data flow requiring the entire flow to be remapped.
0
 

Author Closing Comment

by:tesla764
ID: 40368498
Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question