Answered by:
Package validation error after adding package configurations

-
Hi,
I have created one SSIS package, while move on to production, I have added package configuration as a sql type configuration (I didn't run on my local)and it was running successfully for couple of months as a scheduled job. To add a validation I opened the package but I couldn’t run package in my local, it gave validation error. I thought the package was corrupted, so I got previous version (before implementing package configuration) from source safe and changes are done. After adding package configuration its giving package validation error - error in DFT Lookup task, the mapped column broke in. When I try to remap its giving incompatible column cannot look up. Both columns are same data type; I couldn’t get any reason why its give incompatible data type after adding package configuration.
Please give your suggestion how to solve this.
Thank you.
Question
Answers
-
I think its difference in metadata between your local and production table. First check both objects and see if metadata is the same.
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Tuesday, May 06, 2014 9:05 AM
- Marked as answer by Mike YinMicrosoft contingent staff, Moderator Wednesday, May 14, 2014 4:48 PM
All replies
-
-
-
-
I think its difference in metadata between your local and production table. First check both objects and see if metadata is the same.
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Tuesday, May 06, 2014 9:05 AM
- Marked as answer by Mike YinMicrosoft contingent staff, Moderator Wednesday, May 14, 2014 4:48 PM