Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to run SP which internally conatain Temp tables in ssis Expand / Collapse
Author
Message
Posted Wednesday, June 26, 2013 11:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 02, 2013 12:22 AM
Points: 1, Visits: 13
Hi,

I have one sp which internally using 10 temp tables.

I need to load the result set from sp into one new table using SSIS

I tried delay validation=true and retain same connection=true properties also

Please help me.

Thanks in Advance
Post #1467794
Posted Wednesday, July 10, 2013 9:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 8:05 AM
Points: 285, Visits: 334
Hi

There's no problem run sp, you have to do a few steps:
1. Create a new Data Flow Task.
2. Add OLE DB Source in DFT.
3. Put EXEC "your_sp_name" in SQL Command text.
4. Mark output columns.
5. Add OLE DB Destination and join with new table.
6. Join OLE DB Source with OLE DB destination.

If there are more then one select statements in your sp, it will show columns from the first one, but
it's not a big case.

Br.
Mike
Post #1472214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse