Hi , we are facing a strange issue while executing one our SSIS package. It works on all enviroment excep one. We have checked the software and hardware stack. It is similar to other enviroments. This SSIS is triggered by a ASP.Net application.
1. The issue comes in Paramter mapping in sql execute task. I need to Map a user variable of type int32 to Numeric datatype. It thows a error "invalid precision value". The same code works on all enviroments except this one. If i change the
datatype to Short or Varchar, it works perfectly. Not sure why Numeric fails only on this Enviroment ?
2. But if run the SSIS as a standalone task, instead of trigerring it from ASP.net app, the int32 to numeric mapping explained above works even on this enviroment. So not sure why triggering the ssis it from asp.net fails. Would
there be any diffrence if we run the SSIS through a client or as a standalone.?
I know its a Enviroment issue. But not able to get to the root cause. any pointers would be really helpful.
View Complete Post