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 10th, 2015, 11:40 PM
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
Question How Do I Start SSDT?

Hello,

I'm somewhat new to SSIS and to Visual Studio. I've followed the instructions in the book to download and install SQL Server 2014 Pro, Visual Studio Community 2013, and SSDT. I'm running on Windows 10.1, 64-bit.

I've followed the instructions to create a simple .dtsx package to import from an Excel spreadsheet. Now I want to open that package in Visual Studio and I can't figure out how. (Opening it via Open File, opens it as a XML file, which I don't think is what I want to do.)

The instructions on p. 25 in the book say: "After you download and install SSDT you'll find SSDT in the root of the Microsoft SQL Server program group from the Start Menu." Well, I don't find it in the start menu. Is Windows 10 somehow different? Or is VS 2013 very different from VS 2012? (The examples are of VS 2012.) Any help would be appreciated. I'm sure it's a simple thing. (Actually, being Microsoft, I'm not so sure...)

More Info: I think that I've installed SSDT correctly because when I look in the Programs and Features control panel, I see "Microsoft SQL Server Data Tools - enu (12.0.50730.0)", "Microsoft SQL Server Data Tools 2013" and "Microsoft SQL Server Data Tools Build Utilities - enu (12.0.30919.1)". Is there some further step in installation that I need to do, perhaps?

Thank You
Reply With Quote
  #2 (permalink)  
Old December 12th, 2015, 10:45 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 while to figure out but...

It turns out that it was indeed an installation issue: On p. 24, "... you must download SSDT from the Microsoft download site... Use a search engine with the term 'SQL Server Data Tools for Visual Studio 2013' to find the most recent release." It doesn't however say what parts you need to download.

In addition to SSDT_12.0.50730.0_EN.iso, you will also need to download the SSDT Business Intelligence package, called SSDT-BI, embodied in SSDTBI_x86_ENU.exe which can be found at https://www.microsoft.com/en-us/down....aspx?id=42313.

Note that if you don't read the instructions REALLY CAREFULLY, installation will fail and it won't be clear why. Here is a link to clear instructions by someone else who figured it out: http://postimg.org/image/8arxoo9gz/.

Lastly, there is one more thing you'll need to be able to import/export to/from Excel. If you get an error when trying to run your first import, you will need to add another package: There is some conflict between x86 and 64 bit versions. Download AccessDatabaseEngine.exe from http://www.microsoft.com/en-us/downl....aspx?id=13255.

Sheesh! I think that's it. But then I'm only up to page 25...
Reply With Quote
The Following 2 Users Say Thank You to Bob Alexander For This Useful Post:
enthus1ast (June 17th, 2016)
  #3 (permalink)  
Old June 17th, 2016, 03:36 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: Jun 2016
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
Default

i'm just starting to read this book... i'm glad there is someone else read this book..

by the way, thanks for your great information..
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
Completing Lessons in SQL 2012 SSDT ITGuy268 BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer 0 May 2nd, 2013 11:48 AM
How to Add the 'Start Without Debugging' icon next to 'Start With Debugging' icon btcomp BOOK: Beginning ASP.NET 4 : in C# and VB 1 August 1st, 2010 03:41 PM
don't know where to start timbal25 Access VBA 1 October 18th, 2007 02:17 PM
how to start MunishBhatia ASP.NET 3.5 Basics 3 October 1st, 2007 01:54 PM
how I start it?? italimeme JSP Basics 2 May 28th, 2007 02:07 AM



All times are GMT -4. The time now is 02:25 AM.


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