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.

mckyn (11/20/2014)

---

Thanks for the responses.

Phil - I also did manually run the job from server itself using SSMS and it went fine. Will check again tonight.

Koen - Appreciate the tips...

mckyn (11/20/2014)

---

Hi,

On running the parent package in nightly schedule job gives an 'Invalid access to memory location' error but running from MS VS works fine without error. Log file giving...

Which edition of SQL Server 2012 do you have installed?