migration from 2008 packages to 2016

• komal145

  SSCrazy Eights

  Points: 9918

  More actions

  April 25, 2019 at 6:36 pm

  #3536720

  hi,

  How to get Stored Procedure Result with  Column Types? I need to put this in SSIS pacakge and i have like 100+ columns.

  Execute storedprocedure with results(

  )

   

   

  • This topic was modified 5 years, 7 months ago by  komal145.

• Phil Parkin

  SSC Guru

  Points: 246977

  More actions

  May 2, 2019 at 8:16 pm

  #3631792

  Run the 'guts' of your stored proc, having modified the final SELECT such that it does a

  SELECT INTO [Newtable] .....
  
  FROM etc etc
  
  WHERE 1 = 0  --Don't need any data

  And then get the CREATE TABLE script for Newtable.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel