Can anybody tell me correct syntax

Question

Post reply

Can anybody tell me correct syntax

elchuru

Default port

Points: 1435
More actions
January 2, 2010 at 10:57 am

#140246

Hi,
I am new to SSIS.I defined ReadOnlyVariables "FileName".In script it is showing the following error,which is shown in attachment.Please tell me correct syntax.
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

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

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 1

Can you provide more details as to what you are trying to accomplish?

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

User::FileName

and it's case-sensitive.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

elchuru Default port Points: 1435 More actions · Answer 3

public void Main()

{

Variables var = null;

if (Dts.Variables.Contains("FileName") == true)

{

// Dts.VariableDispenser.LockOneForRead["FileName", var);

Dts.VariableDispenser.LockOneForRead("FileName",var );

}

MessageBox.Show("Found the file: "+var["FileName"].Value.ToString());

Dts.TaskResult = (int)ScriptResults.Success;

}

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

elchuru (1/2/2010)
public void Main()
{
Variables var = null;
if (Dts.Variables.Contains("FileName") == true)
{
// Dts.VariableDispenser.LockOneForRead["FileName", var);
Dts.VariableDispenser.LockOneForRead("FileName",var );
}
MessageBox.Show("Found the file: "+var["FileName"].Value.ToString());
Dts.TaskResult = (int)ScriptResults.Success;
}

This is the correct syntax:

Dts.VariableDispenser.LockOneForRead( "FileName", ref var );

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

elchuru Default port Points: 1435 More actions · Answer 5

elchuru

Default port

Points: 1435

January 2, 2010 at 8:51 pm

#1098210

Its working fine

Thanks CozyRoc