Use a union all transformation to merge the rows and point to one destination.

You can try to do a conditional split and check if the column is null before inserting into destination.

There are some null functions in Conditional Split transformation which can help.

try...

Please check your mapping in destination

If it says it cannot insert a null value then probabaly the destination mapping is incorrect or the values coming in data flow are...

90 percent i'm sure it doesn't work

probably give a try and check the results

There can be a few cases where the derived transformation can fail like the data can come as string instead of a number. So you can use and conditional operator...

Use type Numeric

Change the Data Scale and precision values

When u select the connection and check for the properties you can find a connection string

so add this tag in the connection string value

it'll be like

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.xls;Extended Properties=Excel 8.0;HDR=YES;IMEX=1

I'm sure the query plan will give you a percentage at each checkpoint

so based on the percentages you can determine which operation is taking more time

If it is evenly...

can you try to rebuild all the indexes in sql server 2005 if there are any

Temp tables can be used in ssis 2005

but for this feature to work you shud set the RetainSameConnection property to true in the Oldedb/Sql Connection.

Once you set this the...

Think you shud be using the SingleRow property in execuute sql task and map the output to variables

Use IMEX =1 in the connection property string of the excel connection

that'll set the mode to import and all the values will be populated.

you can deploy the package as a job using Sql Agent and set the job to run at a specific time

i hope this link helps

http://www.mssqltips.com/tip.asp?tip=1180

try adding IMEX = 0 to the excel destination connecting string in the properties attribute

if it works then gud

Properties="Excel 8.0;HDR=YES;IMEX=1"

use a go

that should help