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
2025-09-13T06:17:50.0066667+00:00

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.

SQL Server Integration Services
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lakshmi Narayana Garikapati 555 Reputation points Microsoft External Staff Moderator
    2025-10-27T04:45:53.3266667+00:00

    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

  2. Lakshmi Narayana Garikapati 555 Reputation points Microsoft External Staff Moderator
    2025-10-30T05:32:55.5666667+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.