Alias parameters in SSIS

I found that SSIS will read column names from a stored procedure instead of the SQL command for the OLE DB command!

It will however, not ignore the @ for the parameter name and therefore the intelligent matching does not work for CustomerId vs. @CustomerId.

+1 for everybody that uses Stored Procs. :-)

You can rename them manually in the Input/Output Properties tab (they reside under "External Columns"), but they will always instantiate to PARAM_0, PARAM_1, ...