Wrox Programmer Forums
|
BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
This is the forum to discuss the Wrox book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services by Brian Knight, Devin Knight, Mike Davis ISBN: 978-0-470-49692-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 20th, 2012, 11:58 AM
Registered User
 
Join Date: Jul 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 20 Page 152

Hello,

I have followed all the lessons and so far all of them have worked, but I am having some trouble with Lesson 20, I have followed it to the letter but for some reason the package is failing immeadiately on the LKP - Product Name, the progress shows several errors including the 'The cache is not initialized and cannot be read by component "LKP - Product Name" (113). And then [LKP - Product Name [113] Error: Failed to prepare the cache for providing data. At the very end I get Task DF - Aggregate Data Failed.

Not sure what to do to fix it, and get it working. Any help appreciated.

Regards,
T.
 
Old January 26th, 2014, 10:02 AM
Registered User
 
Join Date: Jan 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is the Lesson that has you change a package you created way back in Lesson 18, I believe.

Most importantly, did everything run fine for all the previous lessons?

If you open the Data Flow for Cache Product Table and right click on the stage > Execute does that Data Flow complete?

In your LKP - Product Name, make sure you have it set to Cache Connection Manager and not OLE DB.

If all else fails, download this package and open it side by side with your package. Check each element and make sure they match exactly.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 20 page 669 Try It Out Step 4 Frodo BOOK: Beginning Visual C# 2010 1 December 14th, 2011 05:17 PM
Errata: page 20 neutcomp BOOK: Professional WordPress Plugin Development 1 June 15th, 2011 08:21 AM
Page 152: equivalence of not-greater-than and less-than-or-equal-to WayneHeym BOOK Programming Interviews Exposed: Secrets to Landing Your Next Job 2nd Ed ISBN: 978-0-470-12167-2 0 June 7th, 2011 02:49 PM
Page 152 typo Kim_arg_js BOOK: Beginning JavaScript 4th Edition 0 July 26th, 2010 07:19 PM
Try it out, Chapter 20, page 684, step 3 ron-bgsu BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4 0 October 28th, 2009 08:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.