{"id":750,"date":"2014-10-28T07:01:35","date_gmt":"2014-10-28T14:01:35","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=750"},"modified":"2014-10-27T11:29:31","modified_gmt":"2014-10-27T18:29:31","slug":"ssis-there-are-some-mapping-errors-on-this-path-troubleshooting","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2014\/10\/ssis-there-are-some-mapping-errors-on-this-path-troubleshooting\/","title":{"rendered":"SSIS: There Are Some Mapping Errors On This Path – Troubleshooting"},"content":{"rendered":"

Dear SQL Server Integration Services Team,<\/p>\n

Would it be possible to get a more specific error message than \"There are some mapping errors on this path\"?<\/p>\n

Your friend,
\nPhil<\/p>\n

\"There<\/p>\n

The tricky problem with this error is getting enough information to troubleshoot it. Here's a nice trick for you: Run the package.<\/p>\n

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. \u00a0Check it out:<\/p>\n

\"There<\/a><\/p>\n

 <\/p>\n

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.<\/p>\n

The fixes are straightforward.<\/p>\n

Option 1: Add the column back to the source query.<\/p>\n

Option 2: Remove the mapping from the destination.<\/p>\n

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.<\/p>\n

\"There<\/a><\/p>\n

Now execute your package and witness your SSIS brilliance!<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,47,43,46,50],"tags":[20,16,10,117,49,48],"class_list":["post-750","post","type-post","status-publish","format-standard","hentry","category-businss-intelligence","category-etl","category-microsoft-sql-server","category-sql-server-integration-services-ssis","category-visual-studio","tag-business-intelligence","tag-files","tag-ms-sql","tag-sql-server-2012","tag-sql-server-integration-services","tag-ssis"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=750"}],"version-history":[{"count":2,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/750\/revisions"}],"predecessor-version":[{"id":756,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/750\/revisions\/756"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=750"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}