+1, I'm not game for that either!

SSIS is extremely fast at INSERTs - I'd suggest leaving those to SSIS.

Updates and deletes I would direct to a staging area and then MERGE via a T-SQL stored proc.

I...

GilaMonster (4/11/2013)

---

It won't be due to multiple executions of getdate. The function is fast, but besides that it will only be evaluated once in the query execution (otherwise you'd get...

Maybe this[/url] article explains it.

Your GETDATE() function is being re-evaluated many times - your faster solution avoids this.

jdbrown239 (4/10/2013)

---

The original file has a row count of 176,864 and even though the row count from sql is 93,456 when I export to txt file and import to excel...

jdbrown239 (4/10/2013)

---

I think I know why the count does not match.

When I exported the data from the sql table (93,456 rows) to a txt file and then imported it...

Are there duplicate rows (by PK) in the source data?

What results do you want to see, based on your sample data?

andrewalex.r (4/8/2013)

---

Company_ID Employee_ID In_Time Out_Time Remarks Entry_Date

17921Task Completed ...

opc.three (4/8/2013)

---

How are your C# or VB.net skills? I am thinking pre-processing the file might be one way. You could use a Script Task to read the file in reverse...

rajeshk 36156 (4/8/2013)

---

this is the error msg..

"CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at...

What is the text of the error message?

It should work. Have you tried setting a pre-execute breakpoint on the task to ensure that the value in the variable is exactly what you are expecting?

This is not easy without knowing more about your data and table structures.

Please follow the link in my signature to see how to post easily consumable DDL and sample data.

Could the fact that 'Destination' is spelt incorrectly in the following be a factor, or is it just a typing error?