Surrogate keys are always the answer if you are dealing with any successful Data Warehouse implementation. For instance take the case of any SCD transformation.

Try using a multi part identifier...such as [database_name].[schema].[table_name]

Hi,

For Question 1: Missing data can virtually mean anything. Creatre a data staging platform where you would add meaning to all data anomolies

For Question 2: Please be specific. I did...

Row Count..the package looks more modular...

Nice...still wondering which is better join or 3 lookup task in SSIS.:-)

da-zero (10/11/2010)

---

I must say, I admire your patience 😀

(5 replies and...

Nice...still wondering which is better join or pivot?:-D

Happy to help. :-):-):-)

bhushan.bagul (10/11/2010)

---

OLE DB Source SQL:

Select customer_key From customer (nolock)

customer_key

-------------

10001

Lookup SQL:

Select customer_key, phone_type, phone_number

From phone (nolock) as ph Join customer (nolock) as c

On ph.customer_key = c.customer_key

customer_key phone_type...

Please provide some sample data to help us help you and what all till date have you tried?

A join on these two tables would be more elegant based on Customer_key:-):-):-)

the.hank (10/11/2010)

---

...

It is difficult to help/replicate help us help you..what errors do you get...did you debugged the application you made???

iNTELLIGENT Mr. Phil :hehe::hehe::hehe:

Phil Parkin (10/10/2010)

---

Come on.

That's a bit like me saying to you: "I have four guys at my house to do some home improvements. Please tell me what...

WayneS (10/10/2010)

---

Well, SSIS does use the Jet driver, via OpenRowSet, to work with Excel files. So, this link will probably help you out. You would just need to add it...