Well, within reason, but if you're going round pretty much the same loop 20 times, I would be doing a fair amount of investigation to avoid having 20 dataflows.

A foreach...

From your screen shot it is difficult to distinguish between long lines (which have wrapped) and true line breaks. Can you widen it to make this clearer? Or just cut...

The result of a union can be thought of as a single table with x rows and y columns with various datatypes - you can't mix and match within that...

The size of the source field (in SSIS) needs to be increased to accommodate the maximum string length from Excel.

If you then want to truncate this before it gets loaded...

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?