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 June 27th, 2011, 05:19 PM
Registered User
 
Join Date: Jun 2011
Location: Brigham City, UT
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default fuzzy lookup lesson 26

The fuzzy lookup package created in lesson 26 fails to complete. I'm not sure if this is because I'm running SQL Server 2008 R2. The Lookup step passes records through to the Union All step and the Fuzzy Lookup step and all these steps turn yellow, but none of them complete. SQLDumper runs and creates a dump file, indicating an error occurred, but the package doesn't do anything more except indicating that is has completed without any errors or any other steps completing. Is anyone else experiencing this problem or does anyone have a solution?

I've tried running the package without the regular Lookup step and it still fails without any errors or completing the Fuzzy Lookup, so I think the problem is in the Fuzzy Lookup step.
Reply With Quote
  #2 (permalink)  
Old March 14th, 2012, 11:54 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Same problem

I am running SQL8R2 all patched up on Win7 Pro x64 all patched up ...
Cannot determine where the issue lies. Match output from Lookup flows to EOJ and lands in the db table. No Match output flows to Fuzzy Lookup and stops there it seems
HELP? anyone? Authors?? Publishers???
Pls advise!

Quote:
Originally Posted by rschmitz View Post
The fuzzy lookup package created in lesson 26 fails to complete. I'm not sure if this is because I'm running SQL Server 2008 R2. The Lookup step passes records through to the Union All step and the Fuzzy Lookup step and all these steps turn yellow, but none of them complete. SQLDumper runs and creates a dump file, indicating an error occurred, but the package doesn't do anything more except indicating that is has completed without any errors or any other steps completing. Is anyone else experiencing this problem or does anyone have a solution?

I've tried running the package without the regular Lookup step and it still fails without any errors or completing the Fuzzy Lookup, so I think the problem is in the Fuzzy Lookup step.
Reply With Quote
  #3 (permalink)  
Old September 12th, 2012, 09:03 AM
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 Same Lesson 26 Fuzzy Issue

Quote:
Originally Posted by tgb25nld View Post
I am running SQL8R2 all patched up on Win7 Pro x64 all patched up ...
Cannot determine where the issue lies. Match output from Lookup flows to EOJ and lands in the db table. No Match output flows to Fuzzy Lookup and stops there it seems
HELP? anyone? Authors?? Publishers???
Pls advise!
Hello, I am having the same issue, I cant find an answer, did either of you work out what it was in the end? I'm running 2008 R2 SP1, then upgraded to SP2 in case it solved it, which it didnt.
Reply With Quote
  #4 (permalink)  
Old January 26th, 2014, 08:36 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

Project > (Project) Properties

Make sure Run64BitRuntime is set to True. You likely changed it to False for one of the earlier lessons.
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
Lesson 8 sergeySE BOOK: Java Programming 24-Hour Trainer by Yakov Fain 1 June 29th, 2011 09:49 AM
Fuzzy maths or what? rushman XSLT 1 February 18th, 2011 11:30 AM
Fuzzy control system picoBrain Need help with your homework? 0 April 20th, 2007 09:17 AM
Fuzzy string comparison (2) kobus XSLT 2 October 11th, 2004 07:28 AM
fuzzy string comparison kobus XSLT 0 September 22nd, 2004 05:47 AM



All times are GMT -4. The time now is 04:51 PM.


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