Saturday, February 25, 2012

Problem creating an enumerator?

Hi,

I tried to create an enumerator using Vb.NET but it will give me an error in this statement:


<DtsForEachEnumerator(DisplayName = "LSParseEnumerator", Description = "Returns an Enumerator by separating items in a String by a certain character", UITypeName = FullyQualifiedTypeName, AssemblyName, Version = 1.00.000.00, Culture = Neutral, PublicKeyToken = "")> _



The error is in the Version = 1.00.000.00 and i have already tried to put it in between "".
Error Returned:
Error 1 Comma, ')', or a valid expression continuation expected. C:\Documents and Settings\Luis Sim?es\My Documents\Visual Studio 2005\Projects\LSParserEnumerator\LSParserEnumerator\LSParserEnumerator.vb 5 217 LSParserEnumerator

Your quoting is off a bit. UITypeName, Version, and Culture should look like this:

UITypeName="FullyQualifiedTypeName,AssemblyName", Version="1.00.000.00",Culture="Neutral"|||Jay i have already tried that to but the example i gave you is from the MSDN2 website so it should be good...

http://msdn2.microsoft.com/en-us/library/ms136120.aspx

The way you told me to use gives me the following errors:
DisplayName is not declared
Description is not declared
and so on for all variables....

The only method that works is

<DtsForEachEnumerator()> _

But this way i can't refer to UI and specify all the other options...

This should be easy i think...
Best Regards,
Luis Sim?es

|||Okay, so much for documentation. I'm still focusing on quoting. Usually those strings look like this:

“Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91”

Have you tried UITypeName="FullyQualifiedTypeName, AssemblyName, Version = 1.00.000.00, Culture = Neutral, PublicKeyToken =" ? Not sure what you'd do about that PublicKeyToken. Quote it? Leave it off?
|||

This is something really odd... can it be from visual studio 2005 express? bug or something?

When is insert the <DtsForEachEnumerator(...
it will tell me that i have all optional parameters like this:

New([Description As String], [DisplayName as String], [ForEachEnumeratorContact As String], [LocalizationType As Type], [UITypeName as String]) Initializes a new instance of Microsoft.SqlServer.DTS.Runtime.DtsForEachEnumeratorAttribute

But i have already tried using just types in that order like this:

<DtsForEachEnumerator("MyEnumerator", "A managed enumerator", "Name of company to contact", , "WorldVision.LuisSimoes.SQLServer2005.Enumerators.LSParseEnumeratorUI, LSParseEnumerator")>

But the following error occurs:
Error 1 Too many arguments to 'Public Sub New()'

This is odd since it gives the parameters and then it shows an empty constructor?

|||Ok problem solved :)


<DtsForEachEnumerator(DisplayName:="For Each String Token Enumerator", Description:="Enumerates string tokens split by a certain separator character", UITypeName:="WorldVision.LuisSimoes.SQLServer2005.Enumerators.LSTokenEnumeratorUI,LSTokenEnumerator,Version=1.0.0.0,Culture=Neutral")> _


Cheers

No comments:

Post a Comment