The fuzzy lookup has not so good performance, so you should do a normal lookup with list B as input and list A as the reference table (since it is...

Set the DelayValidation property of the dataflow to TRUE.

See if that helps...

More information on the SCD:

http://msdn.microsoft.com/en-us/library/ms141715.aspx

http://msdn.microsoft.com/en-us/library/ms141662.aspx

What are the issues that you are facing?

Ol'SureHand (3/8/2011)

---

Not sure I get the point of the trick question.

It should be clear that you can restore to ANY point in time (at each 15 minute interval in this...

Nice article, but in my opinion a bit too much focused on DBA's. There are other people who use SQL Server Agent too 🙂

For example, scheduling the entire ETL flow...

Tom.Thomson (3/8/2011)

---

Kiara (3/8/2011)

---

Koen Verbeeck (3/8/2011)

---

First of all, as it is international woman day, congrats to all those woman out here!

(who for some bizarre reason love to work in an industry...

I shall now pretend I have an amazing sense of humour and say:

Yes, it was deliberate.

😎 :hehe:

First of all, as it is international woman day, congrats to all those woman out here!

(who for some bizarre reason love to work in an industry dominated by men :-))

I've...

smac (3/8/2011)

---

So our administrator created the Credential

Name: OEM PC Admin

Identity: 10.239.130.111\Administrator (since this pc is not on the domain)

Created.

New Proxy, select credential, failed.

Proxy "10.239.130.111\Administrator" is not a valid Windows user.

I...

smac (3/8/2011)

---

Naw I think I will leave it to the administrator 😉

Don't feel like bringing the company to its knees if that is remotely possible!!

Thanks, you've been patient and great...

GilaMonster (3/8/2011)

---

What...

This normally belongs to the tasks of an administrator,...

There was a 4.21 version??? 😛

Waw, what a close finish! :w00t:

In a SQL Server Agent jobstep, you have a dropdown box right under Run As:. In that dropdown box you can select from the various proxies.