Row Count - Variable Name is Case sensitive

I defined a variable called "NoOfRecords" for a Data Flow Task and within the Data Flow Task I am outputting records from Flat File to RowCount before doing anything else. I typed Variable name as "NoofRecords" in Advanced Editor for Row Count and it didnt like it. It gave the following error.

Error at Load Customers[Row Count [138]]: The variable "NoofRecords" specified by VariableName property is not a valid variable. Need a valid variable name to write to

As soon as I changed the VariableName to NoOfRecords, it worked.

It looks like a case sensitive issue.

[578 byte] By [SuthaThiru] at [2008-2-11]

«« SQL Server 2005 Developer CTP Edition - Setup Error
»» Compatibility: Duplicate delegates generated

# 1

Hi Sutha,

Variable names are indeed case sensitive. This is By Design.

Thanks,
Mark

MarkDurley at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

Thanks Mark for clarifying it.

SuthaThiru at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech