Can you load your data from a CSV file rather than Excel? Things will work better if you can change your source.

Is your column really called Column_Name?

Paul Hernández (4/15/2013)

---

Hi Phil,

Thanks for your quick answers.

In my case the source is a OLE DB component, and the reason to do such a things is the final destination is...

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?