Executing a Stored Procedure from a DTS package is very simple while working with a "Execute SQL Task". I would be very glad if anyone could tell me a good way of using Stored Procedures in transformations tasks such as "Data Driven" or "Transform Data Task".