Splendid - thanks for posting back.

Phil

You could maybe try the File Watcher task as an alternative and see whether that works better for you.

+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?