hi can you be more specific about the requirement.

Can you be more elaborative? As far as our understading goes if both the sources are sorted and passed on to a marge transformation then the merge should happen.

instead of using select * from table1

select primay keys of the table as primary keys will have a default clustered index. This will reduce the the number of...

use views when the amount of data is less

If the amount of data which the stored procedure hits is huge then use the temp tables. Using temp tables...

With Data as huge as 132 million it would always be better to drop the indexes and recreate them after the data is loaded.

not at all clear

As far as my unverstanding goes we do not have any support in SSIS 2005 for Lotus Notes.

go thr this link

http://blog.datainspirations.com/2006/08/14/integration-services-miscellany.aspx

Add a Flat File Source and Pass the rows to a row count transformation.

This should do the job.

Use Package Protection Level as EncryptSensitiveWithPassword.

We need to delete the columns and recreate them again.

Dipti: Thanks for the tip. Deploying to a particular folder structure has been a problem in SSIS

If you are using a stored procedure use it like

exec ?,?

map the parameters to the respective fields

if the stored procedure has an output parameter then add the column...

can you check the version of sql server you are using.

I'm able to view the selection for a dtsx package.

I'm using version 9.0

Use a Type 1 SCD Component and use a fast load option in the destination.

PD: Using a trigger fires a query for each insert or update.

Add a job in SQL Server Agent and specify the job to run a DTSX Package

The below link gives you the information

http://msdn.microsoft.com/en-us/library/ms139805.aspx