Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 20th, 2012, 12:58 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
  #2 (permalink)  
Old January 26th, 2014, 10:02 AM
Registered User
Points: 35, Level: 1
Points: 35, Level: 1 Points: 35, Level: 1 Points: 35, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 09: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 03:49 PM
Page 152 typo Kim_arg_js BOOK: Beginning JavaScript 4th Edition 0 July 26th, 2010 08: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 09:52 AM



All times are GMT -4. The time now is 03:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.