I'm transfering a CSV file into a Table .

In Table I have a field called record number which I'd like to insert the
record number of the equivalent record in the CSV file.How can I simulate
it?

Thanks

Ray

You have a CSV file and when inserting to SQL Server you want to have an
incremental integer value added to "Record Number"?

You can either have your destination table have an Identitiy property
attribute or you could use an incrementing Global Variable in an Active
Script transformation.


"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Allan,

I used the second idea and it's now set up.Thanks,

The first idea dsoen't work for me because the line number should be reset
to zero for each student_id.I mean each student id could have multiple lines
which I have handle myself.

Thanks man.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote