hi guys,

i want to convert table 70 GB of data into partition table.

is there any method to do that?

I think you need to:

1) Create a new table that is partitioned and indexes
2) Load the data from the old table
3) Drop the old table
4) Rename the new table to the old table
5) Create any Foreign keys that were dropped when the old table was dropped
6) Do runstats on the new table
7) Rebind any packages that referenced the old table

Andy