I'm trying to execute a stored procedure on a Sybase ASE database and insert
the resulting recordset into a SQL Server database. I can successfully
create both connections, but am having problems with the "Transform Data"
task.

I've entered a SQL command under the "Source" tab and can successfully parse
and preview the resultset. However, I am unable to assign any
"Transformations" since there are no attributes listed under the "Source"
column. When I preview the SQL command I _can_ see the column names. I can
also see the column names when executing the command via a .NET ODBC
connection.

How can I make the source column names appear in the "Transformations" tab?
Alternatively, how can I map transformations without the columns showing?