SSIS data source from multiple-dataset stored procedure

• darth_vodka

  Default port

  Points: 1489

  More actions

  June 22, 2012 at 4:42 am

  #262760

  hi

  if I have a stored procedure that returns multiple datasets, like

  create PROCEDURE [dbo].[zz_Test_Multi]

  AS

  SELECT

  getdate() as Somedate

  SELECT

  DATEADD("d",1,getdate()) as AnotherDate

  go

  if I set an ADO.net source as that stored procedure, it comes up with the first set "someDate"

  is there any way I can access both sets?

• darth_vodka

  Default port

  Points: 1489

  More actions

  June 22, 2012 at 4:57 am

  #1504422

  actually, think I found a solution

  http://www.codeproject.com/Articles/32151/How-to-Use-a-Multi-Result-Set-Stored-Procedure-in

• Phil Parkin

  SSC Guru

  Points: 246956

  More actions

  June 22, 2012 at 5:17 am

  #1504433

  As my Friday good-deed service to lazy people, here's that link again but with URL tags added:

  Link here

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin