Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to Integration Services Expand / Collapse
Author
Message
Posted Friday, March 14, 2014 10:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 3:54 AM
Points: 13, Visits: 3,522
I have started learning the basics and it looks brilliant but note that in the examples given, the tables in AdventureWorks are different from the tables I have in AdventureWorks2012 which I am using. For example in the course, the Person.Person table has a column, EmailAddress but in AW2012 this column doesn't exist but has a column called EmailPromotion containing something different. I can't find out which version this series is using. Can anyone enlighten me.
Post #1551234
Posted Friday, March 14, 2014 3:34 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 11:19 AM
Points: 1,194, Visits: 2,215
Yeah they are different. You need use the DB according to SQL Server Version. They have them from 2005 - 2012.

--
SQLBuddy
Post #1551394
Posted Saturday, March 15, 2014 11:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 3:54 AM
Points: 13, Visits: 3,522
No, still totally confused. I have AdventureWorks 2008, 2008R2 and 2012 and the person.person and person.contact tables are all the same in these versions but they are not the same tables as are used in the Integration Services stairways series.
Post #1551505
Posted Sunday, March 16, 2014 5:59 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:23 AM
Points: 565, Visits: 8,705
Which of the stairway articles are you looking at? In the second one, he is connecting to the Person.Contact table not the Person.Person table.

Russel Loski, MCITP
Post #1551557
Posted Sunday, March 16, 2014 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 3:54 AM
Points: 13, Visits: 3,522
I'm looking for the version I want right now. There is no person.contact table in AdventureWorks2012. Well, not the version I've got.
Post #1551558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse