SSIS Error: VS_NEEDSNEWMETADATA

sql sql-server tsql ssis sql-server-2016
Jonathan Porter picture Jonathan Porter · Dec 29, 2016 · Viewed 42.2k times · Source

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2).

While updating one of the ETLs and trying to run on the new server I got this error:

The package execution failed. The step failed.

Sometimes it also produces this error:

Source: Load Fact Table SSIS.Pipeline Description: "Copy To Fact Table" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

I've tried deleting and re-adding the OLEDB Destination, connection strings and opened up the column mappings to refresh the meta data. I also recreated the whole data flow task but I'm still getting the same error.

The package runs fine on my local machine.

UPDATE:

I started taking the package apart and running only pieces of it to try and narrow down which part was failing. It seemed to be failing on loading into the staging table but I couldn't find out why.

I eventually decided to just try and re-create the whole thing. After re-creating the entire package, still no luck. The picture below is from the event viewer on the server itself but it didn't give me any new information.

enter image description here

Package error from event viewer

Answer

Pavithran picture Pavithran · Nov 20, 2018

I have tried all the solutions provided above and the other sites. Nothing worked.

I got a suggestion from my friend Which worked for me.

Here are the steps:

  1. Right click on the Source/Target Data flow component.
  2. Go to Advanced Editor -> Component Properties
  3. Find ValdateExternalMetadata to False.

Try your luck. This is a pathetic issue and left me clueless for 2 days.

enter image description here

Related questions

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
convert Excel Date Serial Number to Regular Date

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted cells in excel these are converted as 36464 => 1/11/1999 37104 => 1/08/2001 35412 => 13/12/1996 I need to do this transformation in SSIS or in …

Read More
How do I create a step in my SQL Server Agent Job which will run my SSIS package?

I'm trying to create an automated job for the SQL Server Agent to run. The job is supposed to run my SSIS package. Here's what I have so far: EXEC sp_add_job @job_name = 'My Job' ,@description = 'My First …

Read More