SSIS: There Are Some Mapping Errors On This Path – Troubleshooting


Dear SQL Server Integration Services Team,

Would it be possible to get a more specific error message than “There are some mapping errors on this path”?

Your friend,
Phil

There Are Some Mapping Errors On This Path

The tricky problem with this error is getting enough information to troubleshoot it. Here’s a nice trick for you: Run the package.

Wait. What? Why would I run the package if it is already showing there is an error? Well, lucky for us, when you run the package, it will fail but display a much more specific error message which will let you solve the problem.  Check it out:

There Are Some Mapping Errors On This Path SSIS 2

 

In this specific case I get back an error message indicating there is a problem with the VehicleTypeId column. This is a column which had previously existed in my source query and had been mapped to a column in my output flat file but the column had now been deleted from the source query.

The fixes are straightforward.

Option 1: Add the column back to the source query.

Option 2: Remove the mapping from the destination.

To remove the mapping open up your destination task and select “Mappings”. Right click on the line which connects the input and destination columns and select delete.

There Are Some Mapping Errors On This Path Integration Services 3

Now execute your package and witness your SSIS brilliance!

 

 

 


Leave a Reply

Your email address will not be published. Required fields are marked *