No, this isn't an issue like that. It has nothing to do with clustering.

Make your Sequence field a primary key (or simply add a unique clustered index on the field).

What is the SQL contained in the view?

When you say DTS script, what do you mean? Do you mean DTS package or is there some script that runs?