Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, January 23, 2015 2:58 PM
Points: 1,194, Visits: 2,243
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: Thursday, June 16, 2016 12:52 PM
Points: 584, Visits: 8,872
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, MCSE Business Intelligence, Data Platform
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
Posted Saturday, November 7, 2015 3:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 22, 2016 9:43 AM
Points: 2, Visits: 9
has no one come up with a solution for this dilemma. It is totally frustrating. I am even willing all the AdventureWorks databes from the beginning to the end go through all of them until i find the persons.contacts table in the AdventureWorks database... It saddens me that the sample databases are not referenced in some of these series's. So helpful but yet vague...
Post #1734705
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse