I use OLE DB Source, with Data access mode of 'Sql Command'. I put 'EXEC MyProcedure' in the SQL command text area.
Is that the information you needed?
>Sorry but you didn't answer my questions about IS package. What type of data source are you using? How do you cal stored procedure in the package?
>
>>The final line of code is a simple select statement:
>>
>>
>> SELECT FirstName,
>> LastName,
>> MiddleName,
>> UserName,
>> Mail,
>> AllGroups
>> FROM #tmpUsersGroups ORDER BY LastName
>>
>>
>>I have seen messages form others (in blogs) that seem to have this same problem. Perhaps our method is
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.