Post reply

Editing Script Editor

  • October 7, 2009 at 12:11 pm

    #134286

    Hello -

    This has just started happening - I have an SSIS job that has 3 steps on the Control Flow. An Execute SQL Task, a Data Flow and a Script. When I right click on Script and select Edit it comes up with a dialog box. I select Script from the options on the left pane and then click on Design Script - I get an error message 'Cannot show editor for the task.' Under Additional Information I get 'Value does not fall within expected range'

    Any ideas?

    SJ

  • October 8, 2009 at 6:29 am

    #1063387

    shjaffer (10/7/2009)

    Hello -

    This has just started happening - I have an SSIS job that has 3 steps on the Control Flow. An Execute SQL Task, a Data Flow and a Script. When I right click on Script and select Edit it comes up with a dialog box. I select Script from the options on the left pane and then click on Design Script - I get an error message 'Cannot show editor for the task.' Under Additional Information I get 'Value does not fall within expected range'

    Any ideas?

    SJ

    What version of SQL do you use? 2005 or 2008. The first step is step is to review the list of installed addins for Visual Studio and disable one-by-one until you find which one is causing this problem. If you determine the addins are not causing the problem, then you have to reinstall the client Tools for SQL Server.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 8, 2009 at 10:26 pm

    #1063853

    I ran across similar issues some time back when using one my backup dev machines, and it turned out that I was using an RTM (unpatched) version of BIDS 2005. Make sure you've got the most current service pack and patches on the machine on which you're using BIDS.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

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

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