Any VB Scripters out there? $50.00 paypal to the person that can help me finish this.

[PlatinumGold]

I could use a bit of help. I'm using DTS and am trying to create a primary key using first 3 letters of last name, first 2 letters of first name and 3 digits to increment up by 1's when the first five letters duplicate.

it's going from a delimited text file to an odbc file in DTS. that's not that important i guess. What i need is some help doing the VB Scripting.

any hints or help would be appreciated.

 

[PlatinumGold]

bump for urgency

 

[UberDave]

This is why I am not going into this field anymore.

 

[Beau]

What are you using it in? A VB app? ASP page?

 

[LeStEr]

Might be able to help but need a little more info.

 

[PlatinumGold]

I'm using Enterprise Manager from SQL Server. Originally i was gonna use T-SQL, but the active x looked more interesting.

basically if you guys have written any scripts that does this type of thing what i'd like to do is take that script and modify it.