RonKyle (3/5/2010)

---

Why would you never use it? I'm not a big fan of most wizards, but I find this one very...

As far as NOLOCK I always recommend caution while using it. You want to make sure that data in your DW is valid and you didn't get something in-flux.

CEWII

I think the answer to 4 is just fine, I would ask them what they are looking for.

I would ask for clarification for 5. That isn't a clear question....

I'm wondering if the SOAP endpoint should be using SSL (https anyone) that would basically take care of this.

CEWII

I'm not saying it wouldn't work. But most of my data-flows have a lot between the source and the destination. Having NULLs or blanks will OFTEN cause them...

I agree with Gail, ask for clarification.

Don't lie about what you have done, if you say you have done something when they ask you to do it you end up...

I have to say...

Interesting. I think I might have learned something today..

CEWII

I have taken a higher level approach to dtsConfig files. The directory in which they are kept is secured, there are only a few users who have rights to...

My first thought would be that it takes some time to instantiate and start each whole new execution environment. Which is what was happening with a 40 step SQL...

Benefits, yes, you don't have to install anything..

What was the problem with the script task?

CEWII

My first thought is the table that the unscrubbed data is loaded into should have 2 fields, a Record Id which would be an identity and the huge text field...

I do. I"m looking at it to see how you are going to fail it if the numbers are different.

You can capture the record and get the number but...

vijay.msbi (3/3/2010)

---

Elliott,

As you said, \\S-SQL15\IPM Source Data\Source is my relative path as well as my Destination folder.so i can take / in destination variable.

Bu as per you last post,...

You are welcome.

CEWII