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
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 2, 2013 12:22 AM
Points: 1, Visits: 13

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


Group: General Forum Members
Last Login: Today @ 12:46 PM
Points: 458, Visits: 644

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.

Post #1472214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse