Wrox Programmer Forums
|
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 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 December 24th, 2015, 11:58 AM
Registered User
 
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
 
Old December 25th, 2015, 11:20 AM
Registered User
 
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!





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 02: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 05:16 PM
Crystal Viewer - Refresh Excel data problem PatMcM Crystal Reports 0 March 17th, 2006 05:07 PM





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