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 Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
This is the forum to discuss the Wrox book Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer by Brian Knight, Devin Knight, Mike Davis, Wayne Snyder; ISBN: 978-1-1184-7958-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer 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 5th, 2015, 12:14 PM
Registered User
Points: 22, Level: 1
Points: 22, Level: 1 Points: 22, Level: 1 Points: 22, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: San Diego
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 12 SQL Task

Lesson 12 seemed to be a pretty simple concept and perhaps it is but this being my first exposure to SSIS I am apparently missing something.

I can work the example in the book and it works flawlessly so I am thinking that I could modify the example and change result set to a string variable and amend my SQL statement so that instead of returning COUNT(*) for a ProductID it returns the "Name" value for that ProductID.

This however errors out in the SQL Task component of the package BUT when I declare the variable in SSMS and set it to 316 my SQL query performs just as you would expect and returns the "Name" value of "Blade".

What am I missing in SSIS SQL Task that would allow me to successfully execute package?
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 15 - Using the Send Mail Task CHARLIE3402 BOOK: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer 0 November 23rd, 2014 10:47 AM
Lesson 12, Step 5: Question about Interface klp1958 BOOK: iPhone and iPad App 24-Hour Trainer 1 January 11th, 2014 03:47 PM
Lesson 12 mrubin78 BOOK: JavaScript 24-Hour Trainer 5 June 21st, 2013 10:01 AM
Lesson 12 Try It! John S BOOK: Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer 3 June 7th, 2013 01:02 PM
Lesson 13: Task weird output gbargsley BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services 0 August 3rd, 2011 11:07 AM



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


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