Too easy 😀

(especially since you can rule out the "All" answer, as you had to select 2 answers)

The problem is that you are inserting a datatime value directly in your SQL statement, giving the following result (for today's date):

UPDATE g

SET g.[DateTime]= s.[DateTime]

,g.[OrderID]= s.[OrderID]

FROM

[DB1] g

JOIN

[DB2] s

ON g.id =...

That seems OK.

Well, I'm quite out of options. No triggers that are messing with the data?

Sorry, this all I can come up with without looking at the actual package.

voted +1

Can you generate the full CREATE TABLE statement of the table in SSMS. That way we can check the DDL to see if everything is OK there.

Indeed.

You didn't...

Thanks! I...

And now I've reached the 5000-points milestone.

W00t w00t! :w00t: 😎 :hehe:

Ahem.... Back to the tasks at hand... 😀

Carlo Romagnano (5/17/2011)

---

I am curious: bol does not...

I thnk you're better of in the SQL Server 2008 forum:

http://www.sqlservercentral.com/Forums/Forum391-1.aspx

This thread was started in 2007 and was picked up by numerous people over the years.

So the issues are spread out...

ckishore 72107 (5/17/2011)

---

[font="Arial"]try this one:

1)Make a view in the database having the same column names as in excel sheet.

2)copy the data in the excel sheet and paste it in view.

i...

I personally went for a career in BI, but that depends on local job market of course. BI is a very interesting field where there are still some awesome technical...

Duran (5/12/2011)

---

Just wondering, as there is no book for the 2008 BI design exam, I wonder if the 2005 version (Exam 70-446) might be good enough to use instead? Im...

I don't see a real (technical) problem with using schema's to seperate facts and dimensions. It's just a question of taste I guess.

I use schema's to seperate data marts and...