Table partition task

[Philippe]

Hello,
I try the table partition task and I have a question. When I select
the action, it shows the target and the partition table.
Problem is that I cannot type nothing in the target field and if I
click the arrow, it shows a blank list.
I tried two connections, oledb and ADOnet
What am I doing wrong?
Thanks,
Philippe

[Ivan Peev]

Philippe,

This is good question. In order for you to see a table in the target
field you have to have database with a table setup as "partitioned".
The Database Partitions task will not assist you in the creation of
your partition table. It will help you to maintain a partitioned
table.

With that said, you have to first design your partitioned table,
before you can use "Database Partitions Task". A good place to get you
started with your table partition design is:
http://msdn2.microsoft.com/en-us/library/ms345146.aspx

Regards,
Ivan