Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Trying to create a SSIS package

Author  Topic 

kdnichols
Posting Yak Master

232 Posts

Posted - 2007-07-03 : 14:14:28
Hello All,

I am learning SSIS and I am working through the Wrox book on 2005 SSIS. When I try to Import the files from the AdventureWorks2000 database I cannot see the Human Resources files. I was able to go through the wizard once and see the files and select them and proceed, but now I cannot see them. Please keep in mind I am a newby to this. What should I check for or what am I doing wrong?

Thanks,

Kurt

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-03 : 23:53:37
From did you get files? On cd comes with the book?
Go to Top of Page

squashjunkie
Starting Member

9 Posts

Posted - 2007-07-05 : 06:59:01
Sounds like you have the incorrect version.
Check here :
[url]http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en[/url]

Once you have downloaded the files, you can extract them and you must then attach them to the SQL server. You can do this in the SQL Management console :
1. Connect to the server you want
2. Right click on databases and select "Attach..."
3. In the dialog box browse to the location where you extracted the XXXX.mdf and XXXX.ldf files. Select the XXXX.mdf file and then click on OK.
4. Your databases should be present (together with corresponding log files)

Hope this helps.


"Do or do not. There is no try"
Go to Top of Page
   

- Advertisement -