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 SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 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
  #11 (permalink)  
Old April 1st, 2008, 01:22 PM
Registered User
 
Join Date: Mar 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I can understand that. I've wasted 3 days trying to figure this out. Finally got the output variables to work using ADO.NET as the Conn Type, but, as you said, it is FINICKY. I wanted to use the Data Flow Task to move data, but it appears that it doesn't like variables, either, so I'll take my result set and use OLE DB Command to get it into the destination database.

Thanks again.

Reply With Quote
  #12 (permalink)  
Old April 1st, 2008, 01:40 PM
Wrox Author
 
Join Date: Sep 2007
Location: Farmville, VA, USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SSIS lends itself to certain architectures. When I started working with the platform (in an early beta) I was often frustrated by "what I think it should do". Simply put: some things are not intuitive. I recommend attending training or SQL Server User Group meetings on the topic in lieu of training - and also books. There's some good books out there on SSIS. The Expert SSIS book from Wrox is my favorite new book.

:{> Andy

Andy Leonard
Reply With Quote
  #13 (permalink)  
Old April 1st, 2008, 05:23 PM
Registered User
 
Join Date: Mar 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got the Expert book a couple of months ago, and selectively read topics in it. On page 70, it says "Note that when you use parameterized queries, the statement cannot be parsed". That's the least of it, but all it says (of any use) about OLE DB parameterized source queries. I also have the Wrox Professional book, but neither mentions the issues. You are definitively right, it isn't intuitive at all.

Reply With Quote
  #14 (permalink)  
Old May 20th, 2010, 07:28 PM
Registered User
 
Join Date: May 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up

I know this is an old post but I beat my head against this all day today until I discovered that I wasn't using my output parameter correctly. Make sure you don't SET the output parameter anywhere in the proc, only set it at the end when you are done processing. ex:

CREATE STORED PROCEDURE myProc @ID, @blnReturnValue bit OUTPUT

AS

DECLARE @myValue bit

SET @myValue = 0
WHILE
BEGIN
--conditional processing
SET @myValue = 1
END

SET @blnReturnValue = @myValue

GO
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
Chapter 6 "Using SQL Output Parameters..." burkecrosby BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 22 February 10th, 2010 04:33 PM
output parameters with the objectdatasource trancehead ASP.NET 2.0 Professional 2 August 25th, 2008 12:41 PM
Output Parameters Bob Bedell SQL Server 2000 2 March 25th, 2006 05:32 AM
OUTPUT Parameters saulodet ADO.NET 0 May 14th, 2004 10:02 AM
SQL output parameters ohiggs SQL Server 2000 4 February 9th, 2004 09:09 PM



All times are GMT -4. The time now is 11:08 AM.


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