• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

SSIS procedure returns error message

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
tesla764
Asked:
tesla764
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
tesla764Author Commented:
Thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now