SSIS Error: VS_NEEDSNEWMETADATA
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.
I finally found the issue and here's how I did it.
Because the error messages I was getting from SSMS weren't very insightful I first opened up my remote desktop and logged into the server. Then I went to Administrative Tools>Event Viewer and then Windows Logs>Application to see if the failed event would provide greater detail.
It didn't give me much still.
The next step I took was to run the package from the command line because the messages should be more verbose. Opened up cmd, changed directory to the one my package was in and then...
DTEXEC /FILE YourPackageName.dtsx
Finally, the error message here showed a missing column in the tables the package was trying to write to. I added those columns and voila!
- Postgres selecting from table row
- To find the next work day
- SQL Server Left Join With 'Or' Operator
- How to exclusivley select a record from different tables
- Add user to table and use users id while adding data to second table while user registration
- Selecting the earliest row where a specified date value falls between a date range (two columns) when multiple rows may match
- SQL AVG returning an int
- Using two tables. What am I doing wrong here?
- ORDER BY column, with specific notnull value LAST
- How to get the first available number in a range
- In GENERATE_SPREADSHEET SQL on IBM i there are problems if a $ character is present in qualified names
- How to return default value from SQL query
- how to sort a column which contains Semantic Version in Postgres
- Proper Case in Athena SQL
- SQL VBA Query not picking up letter characters, only fully numeric fields
- Joining two tables with a joint result in Postgresql
- Can I Query or Do I Need a Table Function?
- How to link 3 SQL tables and pass 0 value if the value is NULL
- Searching all tables in database containing specific column
- Convert VARCHAR to SMALLDATETIME as part of UPDATE statement
- WordPress - Optimize the Meta Query for 3 meta keys at a time
- How can I find the highest ancestor in a tree?
- Firebird lock and select unlocked fields
- How to pass parameters in a native query JPA
- SQL Server : query columns to JSON object with group by
- SQL Server While loop for last day of month
- Can anyone please explain this solution of hacker rank Binary Tree Nodes?
- generate DDL script from SQL Server database
- How to return name, given an ID Number from same dataset?
- Get the names of all the tables and the views in a single SQL query for SQL Server?