migration from 2008 packages to 2016

• komal145

  SSCrazy Eights

  Points: 9920

  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 6 years, 5 months ago by komal145.

• Phil Parkin

  SSC Guru

  Points: 247180

  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.

  ---