Post reply

ssis package execution error sql server 2008

  • December 18, 2013 at 4:58 am

    #302467

    hi, everyone,

    i have created ssis packages and its working properly in local machine when i upload files from .net.

    but not working in live machine when i upload files from .net(c#) and getting error .

    "The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully."Script Component" failed validation and returned validation status "VS_ISBROKEN". One or more component failed validation. There were errors during task validation. "

    pls i need help.

    Thanks

    Rajnidas

  • December 18, 2013 at 5:01 am

    #1674347

    Do you rely on any specific assemblies in your code? (who might not be present on the other machine?)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 18, 2013 at 5:03 am

    #1674350

    no sir,

    running project at same machine but live project machine.

    thanks

  • December 18, 2013 at 5:06 am

    #1674353

    rajnidas.y (12/18/2013)

    running project at same machine but live project machine.

    Care to explain a bit more?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 18, 2013 at 5:32 am

    #1674367

    it was working in local machine but not in live production server .

    thanks

  • December 18, 2013 at 5:43 am

    #1674369

    rajnidas.y (12/18/2013)

    it was working in local machine but not in live production server .

    thanks

    So, two different machines after all.

    And no special assemblies used?

    Does the server has the same .NET framework installed?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 18, 2013 at 6:03 am

    #1674380

    .net frame are same in both machine

    thanks

  • December 18, 2013 at 6:12 am

    #1674388

    Open up the script component, build it, save it and then redeploy the package.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 18, 2013 at 9:46 pm

    #1674700

    Thanks for your response its working as your suggest.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply