So do you mean that somehow you will check all of the data values in all of the columns, looking for those columns which do not contain any values at...

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