MyDoggieJessie (4/13/2011)

---

Seems like there would be a lot of overhead with that as I'd be comparing a single record from a flat-file against a table that has 50+ million rows?

I'll...

Elliott Whitlow (4/13/2011)

---

I largely agree with Koen, however, for that method to work without issue you have to know that there will be no duplicates coming out of the source....

Elliott Whitlow (4/13/2011)

---

As it sits the pipeline(buffers) from one data-flow are not accessible from another, period, there is nothing that allows that.

With that said I think brian118 was on the...

I must say, after a week holiday, this thread has become very/even more confusing :blink: :hehe:

If it is just for checking if a record exists to make sure you do not have duplicates, I would use a lookup component. Only keep the rows with no...

Small question: what are lakhs?

According to some websites, they are not dangerous unless you provoke them. And that also goes up for the lizards 😉

Dammit, I got it wrong because I've misread the question.

Anyway, it was a great question, thanks Duncan.

With DontSaveSensitive, most...

I usually use DontSaveSensitive with package configurations and I haven't had any real problems (yet).

Regarding the child package: I don't know :blush:

Time to test it out 🙂

You definately should move away from protection levels that have user key in their names 🙂

Either use the DontSaveSensitive protection level (if you are using windows authentication) or use encryptsensitivewithpassword.

You...

Great question, thanks.

You didn't mention the control flow in your question.

Can you explain the complete set-up, as Elliot has asked?

It is not possible to "share" data between different dataflows.

You could create one dataflow with one source and a multicast component to create different flows.

Check out the following thread:

http://www.sqlservercentral.com/Forums/Topic279247-148-1.aspx