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