Can anyone recommend a working sample ETL package created with SSIS?

Question

Can anyone recommend a working sample ETL package created with SSIS?

halifaxdal

SSCoach

Points: 19741
More actions
February 15, 2017 at 12:34 pm

#335006

I am looking for a working package, I came across this one from Microsoft's Tutorial, unfortunately just like many observations, there are missing component(s) in it and I have to do extra work to make it working:

https://technet.microsoft.com/en-us/library/ms169917%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396
It helps if the package is based on any public available sample database like AdventureWorks2008,2012....
Thanks lots.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

not sure if you wanted anyone to send you a dtsx file...but here are links to articles that will get you going.
http://www.sqlservercentral.com/search/?q=SSIS&t=a&sort=relevance

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

halifaxdal SSCoach Points: 19741 More actions · Answer 2

Henrico Bekker - Wednesday, February 15, 2017 12:49 PM
not sure if you wanted anyone to send you a dtsx file...but here are links to articles that will get you going.
http://www.sqlservercentral.com/search/?q=SSIS&t=a&sort=relevance

Thanks but I do appreciate if anyone can share any ETL package (ideally with a public available database like Adventure or something else), and hopefully the package is a working package - not like the disappointed one from Microsoft.

Politically your link is a good starting point, realistically it is not what I am looking for.

Thanks again.

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

halifaxdal - Wednesday, February 15, 2017 12:56 PM
Henrico Bekker - Wednesday, February 15, 2017 12:49 PM
not sure if you wanted anyone to send you a dtsx file...but here are links to articles that will get you going.
http://www.sqlservercentral.com/search/?q=SSIS&t=a&sort=relevance
Thanks but I do appreciate if anyone can share any ETL package (ideally with a public available database like Adventure or something else), and hopefully the package is a working package - not like the disappointed one from Microsoft.
Politically your link is a good starting point, realistically it is not what I am looking for.
Thanks again.

http://msftisprodsamples.codeplex.com/wikipage?title=SS2008%21AWDataWarehouseRefresh%20Package%20Sample&referringTitle=Home

Why not build one yourself with a data source, extract some rows, insert into new table destination, assuming you already have the AW DB in your instance.
There are hundreds of videos on youtube that can show you how to drag and drop tasks.

Realistically you'll learn more that way.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Mr. Brian Gale SSC-Insane Points: 24689 More actions · Answer 4

What is missing in the provided dtsx's from microsoft?
I would imagine that if those were busted a lot more people would complain about them and get them working.

Are you able to start to make a DTSX from scratch? I am wondering if your environment is set up properly if you can't load the samples from that site.

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

halifaxdal SSCoach Points: 19741 More actions · Answer 5

bmg002 - Wednesday, February 15, 2017 3:24 PM
What is missing in the provided dtsx's from microsoft?
I would imagine that if those were busted a lot more people would complain about them and get them working.
Are you able to start to make a DTSX from scratch? I am wondering if your environment is set up properly if you can't load the samples from that site.

I am serious by saying there are missing in the Microsoft's Tutorial (to be frankly this is not a rare case), here is the link:
https://technet.microsoft.com/en-us/library/ms169917(v=sql.110).aspx

If you look at the "Community Addition" part at the page's bottom, you will see the complaints.

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 6

halifaxdal - Wednesday, February 15, 2017 12:34 PM
I am looking for a working package, I came across this one from Microsoft's Tutorial, unfortunately just like many observations, there are missing component(s) in it and I have to do extra work to make it working:

https://technet.microsoft.com/en-us/library/ms169917%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396
It helps if the package is based on any public available sample database like AdventureWorks2008,2012....
Thanks lots.

It sounds like you want someone else to do all your work for you. I believe you'll find that most canned packages are a wee bit too generic and you'll probably end up doing more work fitting a generic solution to your specific needs rather that building what you need.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Mr. Brian Gale SSC-Insane Points: 24689 More actions · Answer 7

halifaxdal - Wednesday, February 15, 2017 7:45 PM
bmg002 - Wednesday, February 15, 2017 3:24 PM
What is missing in the provided dtsx's from microsoft?
I would imagine that if those were busted a lot more people would complain about them and get them working.
Are you able to start to make a DTSX from scratch? I am wondering if your environment is set up properly if you can't load the samples from that site.
I am serious by saying there are missing in the Microsoft's Tutorial (to be frankly this is not a rare case), here is the link:
https://technet.microsoft.com/en-us/library/ms169917(v=sql.110).aspx
If you look at the "Community Addition" part at the page's bottom, you will see the complaints.

I see 1 complaint in the comments section and it is about the lesson plan not about the dtsx's. And it sounds like it is a typo in lesson 1 step 6 where it says DimTime instead of DimDate and lesson 2 leads into lesson 5 instead of lesson 3. I see no complaints about the dtsx sample files being broken.

I am assuming you are using that site because you want to learn SSIS which is why you are not making one from scratch.
What errors are you getting while loading the DTSX?

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.