Thank you for your response, but

In the Bulk Insert command, I can specify the parameter ORDER, NOT ORDER BY.

This parameter lets me load with the clustered primary key already created....

Thank you for your response, but the same apply for SQL Server 2008 right?

Thanks, it is working now, I was so confused that I had the destination engine service with a different ID.

Thanks a lot

This is great ..... Thanks, How about in SQL Server 2000, anything similar?.

Please help.......