Surely if it's temporary, it will not exist at design time and therefore how could SQL Server know about it?

What are you hoping to use the temp table for?

Maybe you could do the copy and then just add the PK constraint back in with some T-SQL at the end ...?

--Removed

select cast(40211 as datetime)

What do you mean, exactly, by 'lose'? What error messages are you getting? Between running the package the first time and running it again, what actions are you taking? (Edit...

You are still not giving us the whole story. That, combined with the fact that your English is a bit dodgy, is making this more difficult to understand than it...

Maybe have a look at this thread too ... It sure helped me at the time.

What have you tried so far? What problems are you having? What problems are you envisaging?

steveb. (12/8/2009)

---

You should be able to do this in SSIS,

however your description is not clear.

Here in example first column stars with '8' and fifth column '3' and...

Script task will do it in about 5 lines of code ...

If I understand correctly, you want the user to fire off a package which reads an Excel file from their PC?

Assuming that SSIS is installed on a network server and...

I would guess that those 'numbers' you are referring to are the number of days since 1/1/1900 (or 1899, or whatever the base date is) - which is how Excel...

OK, so ... what is your question?

A couple of lines of sample data will probably help people picture what you are trying to do.

OK what is the nature of the PK on the orders table - is it sequential/ascending?

(If it would help this problem) can you add any fields to either of the...

Can order rows be inserted/modified after creation? Or does this problem merely boil down to taking across order headers/details for those orders which do not already exist in the target...