Date: 05/31/07 (SQL Server)    Keywords: database, sql

Okay, this one's got me stumped...

I'm converting SQL Server 2000 DTS packages to SQL Server 2005. It seems like what I'm trying to do should be simple: An Execute SQL Task runs a stored procedure, then stores the output in an Object called ResultSet. (The Execute SQL task isn't working, but that's beside the point right now.) Now, what I need to do is export the result set into Excel. Simple, right? Take the result set and export into Excel using a data flow.

Except, umm, there doesn't seem to be any source in the data flow screen that specifies a variable. I realize the easiest way to do this would be to store the results of the stored procedure in an actual table and just export the table to Excel, but I'm not entirely sure I have create permission on the database.

Anyone tried to do this? Is there something painfully obvious that I'm overlooking? Thanks.

Source: http://community.livejournal.com/sqlserver/59141.html