Sounds like a new dance move!!

Anyhow, I think we need to see the query which generated this error. I am suspecting that there's an implicit...

tmac3217 (11/25/2014)

---

We've run into some goofy metadata issues even with 2008. To work around them, we add the following as the first query within all of our stored procedures:

[font="Courier...

English translation, anyone? 🙂

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