It's not clear from your post where you're running the select; in script task, in execute sql task, or in data flow?