Did u rule out any data type conversions (like for ex: coming from DB2 source to SQL Server dest, even though the data type is datetime or similar on both...

This is a quick read and one of the most frequent prob in SSIS.

http://www.expertsqltraining.com/viewarticle.aspx?id=76

elegant vs efficient .. i guess elegant wins.

🙂

Use OLEDB connection managers (much faster than ADO.NET... u dont necessarily have to use ADO.NET).

Map the SSIS variables to parameters of the stored proc based on ordinal positioning of the...

You can apply CHECKSUM(AllColumnsSepBycommas) in your SELECT in the Data Flow Task Sources (on both sources of merge join).

[ps - u can automate this from the metadata]

Mod your SELECT to SELECT ColumnNames, CHECKSUM(ColumnNames) AS 'Checksum_Column'.... if u can mod the query.

have u tried using BIDS Helper

http://www.codeplex.com/bidshelper/Release/ProjectReleases.aspx?ReleaseId=9557

Cool. Now i also have numbers to back my technology suggestions for using SSIS for transfers.

Do you have any configurations for your connection (to excel)

No problemo.

Could be the PK, but is it the only key on that table

david,

i think the TABLOCK is already being specified.

dndaughtery , Maybe your transaction log is getting filled up or growing at a very rapid rate (ok, on this point i...

David, u can change the batch size and commit size the destination adapter...any other difference?

Just have the table lock checked, remove any null checks, constraint checks.

set the batch size to 100000 and commit size the same.

Do you have any transformations between the RAW source...

David, i have question - doesnt the data flow task execute Bulk Insert when u use the fast load option? (if u see from profiler it says Insert Blulk but...