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: Professional Microsoft SQL Server 2014 Integration Services
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2014 Integration Services by Brian Knight, Devin Knight, Jessica M. Moss, Mike Davis, Chris Rock; ISBN: 978-1-118-85087-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2014 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 December 24th, 2015, 10:58 AM
Registered User
Points: 16, Level: 1
Points: 16, Level: 1 Points: 16, Level: 1 Points: 16, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2015
Posts: 4
Thanks: 0
Thanked 2 Times in 1 Post
Unhappy Where Is the Data Profiler Viewer?

Hello,

On p. 48 it says "You can view the structured output file that is produced by the Data Profiling task in a special Data Profiler Viewer that provides drill-downs back to the detail level. To access this viewer, select SQL Server -> Integration Services from the Start menu."

I don't see "Integration Services" in the SQL Server group in the start menu. As before, I've followed all the installation instructions.

Any ideas? Does it have a different name? I'm guessing it's an installation issue. (I'm running SQL Server 2014 and VS Community 2013 on Windows 10 Pro)

Any help would be appreciated.

Thank You
Reply With Quote
  #2 (permalink)  
Old December 25th, 2015, 10:20 AM
Registered User
Points: 16, Level: 1
Points: 16, Level: 1 Points: 16, Level: 1 Points: 16, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2015
Posts: 4
Thanks: 0
Thanked 2 Times in 1 Post
Talking Solution Found

It took a little while to figure this one out as well. It is not an installation issue.

The executable that needs to run is called DataProfileViewer.exe. On my system it is found in
C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn.
MSDN lists the location as
<drive>:\Program Files (x86) | Program Files\Microsoft SQL Server\110\DTS\Binn.
So, it could be in "Program Files", not "Program Files (x86)". It might be in 110, 120, or some other subdirectory.
https://msdn.microsoft.com/en-us/lib...ql.120%29.aspx

If you are running Windows 8 or 10 you can just search for the executable from the start menu.

Why doesn't this show up in the start menu by default? I don't know. Is it a Windows 10 difference? Is it a change in the installer? I don't know.

I would like to see Wrox include an "Installations" chapter at the very beginning of the book that would go through a check list of all that needs to be running for the examples in the book. Since that's a moving target (e.g. Windows 10 released after the book is released) it there should be an Installations page associated with this book (and others that require software installation). That page can be updated by Wrox or us bloggers with check lists of what needs to be installed and links of where to find them, as well as what to do when items can't be found. For example, it doesn't give the name of the executable in the book. It should list it somewhere so that we don't spend huge amounts of time web searching for solutions that should be there in the book. End of rant!
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
Profiler and procedure calls joxa83 SQL Server 2005 0 September 9th, 2008 03:41 AM
Automating SQL Profiler cannonier SQL Server 2005 1 January 24th, 2007 01:38 PM
VBA memory profiler mvick VB How-To 1 September 27th, 2006 03:08 PM
Crystal Viewer - Refresh Excel data problem PatMcM Pro VB.NET 2002/2003 0 March 17th, 2006 04:16 PM
Crystal Viewer - Refresh Excel data problem PatMcM Crystal Reports 0 March 17th, 2006 04:07 PM



All times are GMT -4. The time now is 01:54 AM.


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