Is your solution complex? Are there many packages?

You could just create a new solution and import the packages into that.

Just for your future information, there are several contributory reasons for the lack of answers, I suspect.

1) Your...

Excel and SQL Server have different dates for 'Day 0'.

In Excel, it is 1900-01-00 and in SQL Server it is 1900-01-01. That accounts for one day's difference.

The other day I...

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...