SSIS Package error

Posted on 2011-10-03
Last Modified: 2012-05-12
I am trying to run a ssis package and I get the following error message :

Failed to lock variable "intDelayTime" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".  

I have declared the variable intDelayTime as Int32 in the variable list but still I get the above message. Please help. Thanks.

Question by:Rdichpally
    LVL 11

    Expert Comment

    by:Simone B
    First thing to do is to check the scope of the variable that you created.
    LVL 16

    Accepted Solution

    Click on the task that is giving you this Error and then Go to Variables and check for the variable..If you don't see it in the list then it is a Variable Scope Issue, meaning that the variable is not in scope for the task to use it.. delete the variable and create it globally to be be used in the package
    LVL 21

    Expert Comment

    Check the correct spelling , it's case sensitive.

    Also check the scope as other's change the scope ,either delete and recreate the variable or download BIDS HELPER

    Also if you're using a script task, make sure not to forget to add the value as read only or read write..

    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please make sure the scope of the Variable.

    It is for whole package or any of task.

    If variable is define for any of task then it will not available outside that task.

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Need help with a query 7 53
    Adventure works database .msi 4 41
    Dataset not reading table data 12 36
    How to enforce inte 8 27
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now