Calling a stored procedure from DTS

[mepancha]

Hi,
I would like to know if a SQL Server stored procedure would be called from DTS, if yes can you'll please let me know as to how this could be done.
Thanks & Regards

 

[dbomrrsm]

Yes

with an execute SQL task

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[yksvaan]

And besides SqlTask I think you also can put EXEC proc as source sql, so you get the result set data to be transformed to destination.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]