Can you possibly attach a screen shot showing how things are connected?

Have a MERGE proc and call that instead?

I would refine your REPLACE slightly to include the '.' - this would help avoid the problem Mark mentioned.

update Documents

set DocumentFileName = replace(DocumentFileName, '.TIF', '.pdf')

where...

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...