The SSIS Data Pump - Level 2 of the Stairway to Integration Services

Question

Post reply

The SSIS Data Pump - Level 2 of the Stairway to Integration Services

Viewing 7 posts - 61 through 66 (of 66 total)

You must be logged in to reply to this topic. Login to reply

s_streeting SSC Enthusiast Points: 109 More actions · Answer 1

Hi,

Which version of the Adventureworks database is this Stairway written for?

I have Adventureworks2008 and 2008R2, and when i start the tutorial for level 2, it refers to table Person.Contact.

I don't have this table in my either of my databases.

I would really like to go through this Stairway, as i have no experience if SSIS.

Thank you.

Shane

Rich Parsons SSC Veteran Points: 237 More actions · Answer 2

Rich Parsons

SSC Veteran

Points: 237

April 21, 2014 at 3:16 pm

#1707576

Hi Andy - I can't seem to find a copy of the sample db. Would you be so kind as to post a link?

Cheers,

Richard

Rich Parsons SSC Veteran Points: 237 More actions · Answer 3

Rich Parsons

SSC Veteran

Points: 237

April 21, 2014 at 3:20 pm

#1707577

Hi Andy,

Just found your link to the db, so please ignore my most recent post. Apologies, I should have read through the posts first.

Cheers,

Richard

dgutierrezd SSC Rookie Points: 38 More actions · Answer 4

So, I had the AdventureWorks2008R2 database installed.

What i did instead of selecting the Persons.Contact Table, is:

Chose SQL Command

and Joined the 2 Tables that have the information as such:

USE AdventureWorks2008R2

SELECT P.FirstName, P.MiddleName, P.LastName, E.EmailAddress

FROM Person.Person AS P

LEFT JOIN Person.EmailAddress AS E

ON P.BusinessEntityID = E.BusinessEntityID

When I preview the information comes out as it's supossed to.

But when I run the SSIS Project, it creates the table, but it doesn't insert any of the data.

Can i get some guidance please?

martinamis SSC Rookie Points: 31 More actions · Answer 5

Hi, the link for the Adventureworks DB is no longer active. I was able to complete the exercise by using adventureworks2008r2 and making a view and adding it to the Person schema

USE [AdventureWorks2008R2]

GO

/****** Object: View [Person].[Contact] Script Date: 11/24/2015 13:55:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [Person].[Contact]

AS

SELECT Person.Person.*, Person.EmailAddress.EmailAddress

FROM Person.Person INNER JOIN

Person.EmailAddress ON Person.Person.BusinessEntityID = Person.EmailAddress.BusinessEntityID

GO

miballenger Grasshopper Points: 15 More actions · Answer 6

Andy, working my way through these tutorials now as a bit of cross-training. Finding them much better than anything else out there for completeness.

Just wanted to let others know that the AdventureWorks database is from 2005. It can be downloaded from Microsoft's codeplex site at http://msftdbprodsamples.codeplex.com/releases/view/4004.

jetboy2k Mr or Mrs. 500 Points: 529 More actions · Answer 7

I just started "climbing" this stairway, and I ended up downloading and installing the AdventureWorks 2014 DB. Immediately you see a couple of differences. The first one is that there is no Person.Contact table, instead you end up using the Person.vAdditionalContactInfo view. No big deal, easy enough to modify the query.

But the second thing you see is, after configuring the Data Flow task and debugging it successfully, it turns out to only operate on 10 rows, not the 19K+ that is shown in the examples.

Again, not a big deal, but it would be nice to be able to validate the results against the walk-throughs.

So all of this is a roundabout way of asking - what version of the AdventureWorks DB is used for the Stairway? I'd like to install that one and use it going forward.

Thanks.