Symptoms
Moving a process from dev to production. I have a process that uses smartobjects created from a SQL Server service instance. I need to know how to properly package and redeploy a process from my dev server to my productions server the easiest and most efficient way. I would rather not have to recreate my smartobjects from scratch
Diagnoses
They key in moving one workflow from one environment to another when it includes a Service Instance is that the Same Instance exists on the destination environment. In your scenario is that the SQL db has the same structure in Dev and Prod (At least for the SMO's being used.
Resolution
There were some erros during the package which were cleared by removing a disabled rule not in use. After that the Multi Select Control style was all wrong. Repairing the SmartForms Control pack in production resolved the issue.