At the top of page 47 it says "2. Now you can add the connection manager directly to the package, which will be an OLE DB connection to the AdventureWorksDW2008 database named the same." I am very unclear as to what to do here. I have spent hours trying to get this to work the way the book seems to want me too until I am frustrated. Do I manually create a new connection named AdventureWorksDW2008? Do I add this to the already created connection SSIS_PDS? I could sure use some adive before I throw this book out the window or burn it in my fireplace. Thanks

I share your pain having spent my weekend working through the same few pages but the good news is it all works in the end so hang in there!

The connection manager it is talking about is in BIDS at the bottom of your work area. Right-click in the blank space in the "Connection Managers" section and choose "New OLE DB Connection...".

Create a new connection to the AdventureWorksDW2008 database on your localhost. Then rename it (right-click) when you're done to remove the "localhost." prefix.

Then click to select it and check the properties pane over on the right-hand side of your work area. Find the 'Expressions' property and click the ... ellipses to the right of it. Then enter '@[User::connAdventureWorksDW2008R2]' in this property as per Figure 2-8 in the book.

Now you still need to enter a row into the SSIS Configurations table which will then be used to set the Value property of the connAdventureWorksDW2008 variable which will then tell your new connection manager what connection string to use.

See how you go with that :)

Fantastic, that worked! Thanks! However, I can not save the project. I am getting an error saying that my 64 bit version of Visual Studio 2008 is not loaded correctly. I uninstalled it and reinstalled it and same error. Sigh.......

Can you post the error message? I'm running on 64-bit W7 Ultimate just fine but my VS is 32-bit according to task manager. v9.0.30729.4462.QFE

Failure saving package.

An Integration Services class cannot be found. Make sure that Integration Services is corrctly installed on the computer that is running the application. Also, make sure that the 64-bit version of Integration Services is installed if you are running a 64-bit application. (Microsoft.SqlServer.DTSRuntimeWrap)

MrClean,

I'm sorry that you're having trouble setting up the framework. For further information on connection managers, may I recommend that you start with the Professional SSIS book, as recommended on page 37?

As for your project error, can you try reinstalling the SQL Server client tools on your machine? That is where the SSIS project pieces come from.

Jessica

Now when I start the package I get the following:

Message 1 Information while loading SSIS_PDS_Template.dtsx: The package is attempting to configure from the XML file "C:\SSIS_PDS\CH02_Framework\SSIS_PDS_Management_Fr amework.dtsConfig". C:\SSIS2008\Projects\SSIS_PDS_Template\SSIS_PDS_Te mplate\SSIS_PDS_Template.dtsx 1 1


Error 2 Error loading SSIS_PDS_Template.dtsx: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager. C:\SSIS2008\Projects\SSIS_PDS_Template\SSIS_PDS_Te mplate\SSIS_PDS_Template.dtsx 1 1

Mr. Clean,

The error message is saying that it can't understand the configurations. It looks like there may be an extra space in the word Framework - try removing this and reopening the package.

Jessica