Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can we use stored procedure inside DTS
- Thread starter 13415
- Start date
I know you can execute a stored procedure in a DTS package.
Use the "execute sql task" button. Just put your sp name in the sql statement box. But I don't think you can transfer data from a temp table (created in the Sp above) to an another destination.
But maybe the "transform data task" has enough possibilities to change your data. Experiment with that a little.
GL, Rosko
Use the "execute sql task" button. Just put your sp name in the sql statement box. But I don't think you can transfer data from a temp table (created in the Sp above) to an another destination.
But maybe the "transform data task" has enough possibilities to change your data. Experiment with that a little.
GL, Rosko
- Status
Similar threads
- Locked
- Question
