sql server dts: record number in data pump task -- sql server dts

Re: record number in data pump task

Allan Mitchell
3/6/2005 9:27:35 AM

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.

[quoted text, click to view]

Re: record number in data pump task

RayAll
3/6/2005 11:54:37 AM

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.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.