Solved

SSIS procedure returns error message

Posted on 2014-10-08
2
151 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

770 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