Local is 4.8 QA Is 4.5 Prod is 4.8 developing on local. But still on prod not works and gting error. Like cannot upgrade script component. Please help me. Tried with many options and tired. QA is Working and and same package deployed on prod fails

ram naveen 0 Reputation points

Local .NET is 4.8, QA Is 4.5, Prod is 4.8. changed 2 columns lengths in SSIS and not any major changes. developed on local But still on prod not works and giving error Like cannot upgrade script component. Please help me. Tried with many options and tired. QA is Working and and same package deployed on prod fails with above said error. Not sure what happens. BUT PACKAGES structure: AFTER OLE DST destination( summary table) there is only script and the error related DRE, OLE DST.

0 comments No comments
Sign in to comment

Answer recommended by moderator

Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

Hi @ ram naveen,

Thanks for sharing the details   based on what you've described, it sounds like the issue is due to a mismatch between the SSIS runtime or metadata compatibility in PROD, even though .NET 4.8 is installed. The script component may not be upgrading properly because of stale binary references or version tags embedded during development. I’d suggest re-editing the script component (even a minor change like adding a comment), rebuilding the package fully, and deploying via ISPAC if possible. Also double-check the SSIS runtime version on PROD to ensure it matches QA. If the issue persists, recreating the script component from scratch in a PROD-compatible environment might be the cleanest fix.

Thanks,

Lakshmi.

0 comments No comments
Sign in to comment

1 additional answer

  1. Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

    Hi @ram naveen,

    I wanted to follow up and confirm whether you’ve had the opportunity to review the information   provided If you have any questions or need further clarification, please don’t hesitate to reach out.

    Looking forward to your response.

    Best regards,

    Lakshmi.

    1. Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

      Hi @ram naveen,

      I wanted to follow up and confirm whether you’ve had the opportunity to review the information   provided If you have any questions or need further clarification, please don’t hesitate to reach out.

      Looking forward to your response.

      Best regards,

      Lakshmi.

    Sign in to comment
Sign in to answer

Your answer