 | |
how to read 2 resultsets coming from sybase proc?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
how to read 2 resultsets coming from sybase proc? -
02-11-2004
, 02:55 PM
#2
| |||
| |||
|
|
All, My DTS calls a sybase stored proc which returns 2 resultsets. They should be mapped to 2 different tables A & B, respectively. How do I do this? I am using SQL2k. Regards, -j- |
would be to split the stored proc into two.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#3
| |||
| |||
|
|
-----Original Message----- In message <e9ea01c3f0e1$50c45da0$a001280a (AT) phx (DOT) gbl>, jonam anonymous (AT) discussions (DOT) microsoft.com> writes All, My DTS calls a sybase stored proc which returns 2 resultsets. They should be mapped to 2 different tables A & B, respectively. How do I do this? I am using SQL2k. Regards, -j- I'm afraid you cannot handle multiple resultsets in DTS. Your best bet would be to split the stored proc into two. -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.