Post reply

migration from 2008 packages to 2016

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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply