Actually, that reminds me.

Here is a quote from BOL:

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in a future release of SQL Server. Avoid using SET ROWCOUNT...

Try comparing the execution plans for each. If they are the same, you have your answer.

OK, I think I understand what you want. But what is your question?

--Edit: Jack's on to something. Use an asynchronous Script Component for this.

If, for reasons of scaling and performance, you think that your DW database will, or may, reside on a different SQL instance from your OLTP database, you should also consider...

vecerda (11/24/2014)

---

Hello,

I have a requirement to load data from the attached file.

It is a .txt file that has a repetitive structure with 7 attributes per record. Please, see the attached...

stevefromOZ (11/21/2014)

---

Hey Phil, whadidya call me?!?! LOL

I know, it seems strange but i couldnt think of how else to describe it.

Maybe a better way is - ragged right...

Some more info here[/url].

Oxymoron, anyone?

What is it about 2012 that makes you think it will be a better solution for you in this case?

Why would you avoid going for 2014? Most of what...

A nested REPLACE should...

I think that the 'right arrow' is a tab.

So if you replace tabs with spaces before doing your verdana replace, you should get more hits.

Are you able to view the data in something like Notepad ++ and do View / Show Symbol / Show all characters

just to confirm that there are no tabs, double...

Change the properties of your lookup component so that its lookup is not cached.

It will hit performance hard, but it should do what you want.

OK, the desire to find out how to do this has been only tepid, so I'm not going to spend hours writing things out in great detail. Let's consider one...

Thank you for the informative response.