SSIS script object

  • Hello,

    I added a script object (VB.Net) and am trying to add a vbscript but the Design Script button does not open up the script editor screen.

    Not sure what set up I need to do.

    +ive

  • This are a number of issues that can cause this problem. When it happened to me, I fixed the problem by updating to the latest sql server service pack.

    A couple of other possibilities are:

    Your computer does not have all the required dlls successfully registered.

    The script code that SSIS is trying to open contains > 1 function or event procedure with the exact same name. To test, open the dtsx in notepad, and search for that problem.

    There is a good thread at

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/20f4e39e-d937-436d-8066-27d34e57e30d/

    that covers many of these issues.

    ken

Viewing 2 posts - 1 through 1 (of 1 total)

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