Showing posts with label adventureworks. Show all posts
Showing posts with label adventureworks. Show all posts

Tuesday, February 21, 2012

Sample files for Adventureworks SSIS

All,

I am very new to Sql Server and just starting in BI.

I want to do the SSIS tutorial, but even though I have been able to attach the Adventureworks DB, I can not find the flat files that are to be loaded in the tutorial. Is there some place where I can download them from?

Any other options?

Thanks for your help.

Installing SQL Server copies the samples from the CD to the harddisk but doesn;t install them by default.

Go to Start -> All Programs -> Microsoft SQL Server 2005 -> Documentation and Tutorials -> Tutorials-> SQl Server Tutorials
Go to Start -> All Programs -> Microsoft SQL Server 2005 -> Documentation and Tutorials -> Samples Directory->

Alternatively

SQL Server 2005 samples and sample databases can be found @. http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

Thanks,
Loonysan

.

sample database about sqlserver2005

I had installed the sample database "AdventureWorks ",but i couldn't find it in SQL Server Management Studio,and I noticed than it was installed into "Microsoft SQL Server 2005 Samples" directory,but not "Microsoft SQL Server" directory,what can I do to find the datebase.

I am a beginner,and learning sqlserver by using tutorials,someone help me?

many many thanks.

Open the folder and you will see the file you need to copy into managment studio and execute to create it. It is the only .SQL file open it copy it and execute it in managment studio. Hope this helps.