dprice7
asked on
activex script in DTS
Hello,
How would I create a counter in an activex script.
For instance I would like to have a variable called counter and increment it.
Dim counter= 0
DTSDestination("fielda")= counter + 1
What I get now is the all records have a 1 instead of incremented value.
I would like fielda to contain the new value for each row read.
thanks in advance,
Don
How would I create a counter in an activex script.
For instance I would like to have a variable called counter and increment it.
Dim counter= 0
DTSDestination("fielda")= counter + 1
What I get now is the all records have a 1 instead of incremented value.
I would like fielda to contain the new value for each row read.
thanks in advance,
Don
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you're interested there may be a way to do this without code using an IDENTITY field.
ASKER
I want to split the points so I can split them.