July 27, 2011 at 5:13 pm
I'm following SQL server books online. I'm making a simple ETL package. It is asking to add AdventureWorksDW on the OLE DB connection. The sample database exsists on my computer, but for some reason it's not being recognized by the connection manager.
I tried using the AdventureWorksDW2008R2 data base. It doesn't correspond to the lesson. I also tried re-installing the sample DB's from codepress. Is there someway to get it in the 'Connect to a database group' in the OLE DB Connection manager?
July 28, 2011 at 2:52 pm
Are you using Windows Authentication in connection manager? Usually when you can't see a database that you know exists it is either a permissions issue or the database state issue (Offline, Suspended ect)
July 30, 2011 at 12:26 pm
Thanks for the suggestion,
I found out that I had to download a 64 bit version(s of AdvetureWorksDW2008R2 DBs and non DB sample files) off of codeplex, as well as uninstall the old version of 32 bit AdvetureWorksDW2008R2. I had confused myself being that I just got a new 64 bit laptop and not used to the 32/64 bit concept.
It still won't Debug some of the sample packages but at atleast can see them and get the gist of it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply