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 incorrect. I am a little new at 05.

>What type of data source are you using? I can map columns from OLE DB datasource with SP as SQL command to a flat file destination.
>
>>Thanks for your reply, Sergey, you always seem to be able to help. :)
>>
>>In this case, I did as you indicated in the begining, and the source is linked to the destination, but the fields from the source are not able to be linked to the fileds in the destination. I can even preview the result set from the procedure. It seems that SS05 is unable to see the fields (field names) that come from the procedure to be able to link them to the destination fields. Without this step, you can not save that step in the package. It won't complete (unless, of course, I am doing something wrong). I have only been working with 2005 for a month or so, and am unable to find documentation on this particular implementation.
>>