SSIS VS_NeedsnewMetadata

Posted on 2012-09-12
Medium Priority
Last Modified: 2012-09-28
Hi all i am using a package that takes tables from a foxpro Database and puts into Sql

the foxpro database has recntly been upgraded to a different version and ever since then my package is failing.

i get the following

"Error Component source 8 dmcomp (2987) failed validaion and returned validation status VS_NeedsnewMetaData"

i have checked that no new feilds etc have been created in the upgrade and cannot see anything.

can anybody help

Question by:pepps11976
  • 2
  • 2
LVL 12

Expert Comment

ID: 38390750
It is far from elegant, but if you edit your package and open the components in your data flow, it will prompt you for automatic metadata updates.
Then save a redeploy your package.

I'll be watching eagerly to see if anyone else has another method to deal with this.

Author Comment

ID: 38390764
Yes i have already tried that however it seems to be still failing


Author Comment

ID: 38390987
ok i am going to try to takethis one peice at a time hope someone can help the first error tha i am getting in my package now is

Cannot insert the value Null into column 'hourcharge' table DB_opera_copy.dbo.dmcomp' column does not allow nulls insert fails

Does anybody know how i can get this to accept Nulls
LVL 12

Accepted Solution

Jared_S earned 2000 total points
ID: 38391024
This will do it, but be sure to replace varchar(25) with your data type

use DB_opera_copy
 alter table dmcomp
 alter column hourcharge varchar(25) null;

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

809 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