Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Validation error. Build Files Count VIE [245]: The variable "(null)" specified by VariableName property is not a valid variable. Need a valid variable name to write to.

From what I can tell, this error is thrown when a variable is not assigned to the VariableName property; however, I definitely have a variable assigned, as seen in the image below:

"Count VIE" Row Count Properties

I've deleted the Row Count component and remade it, but the error continues to show up. Here is a snapshot of the Data Flow in question:

"Build Files" Data Flow

I'm not sure if its inclusion in a Conditional Split may be causing this error, but none of the other Row Count components seem to be throwing this error.

share|improve this question
    
Are you typing or selecting the variable name? Variable names are case sensitive in SSIS so Could you post a screenshot of this variable? What I'd like to verify is the Name, Scope and Data Type are expected. Additionally, if you are taking advantage of inheritance and the variable is declared in a parent package, you might need to set the data flow as DelayValidate=True –  billinkc Sep 27 '12 at 15:30
    
While your variable is assigned, perhaps the way you are populating the variable is causing the issue. At runtime how is it populated? perhaps you have a config entry that is not populated or the result set of a query. - these are just a couple of examples. If you provide more detail that would be helpful –  CPU_BUSY Jan 18 '13 at 15:36
    
I'm unable to reproduce this. The only scenario where I get that error is when the variable is unset. Any time there's text in the variable name field, it gets returned in the error, regardless of whether or not the variable exists. There may be a bug in the designer. Try comparing the XML of the .dtsx between one of the Row Counts that works, and the one that doesn't. –  Jon Seigel Jan 18 '13 at 18:37
    
i got the same error, finally did nothing but save/close the package and re-open it. err went away –  user25432 Jun 27 '13 at 15:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.