Hi

I'm exporting data using SSIS from a stored procedure call to an EXCEL
destination. I can set the Excel column names to the names of the fields
returned via the stored procedure. I however need to set these column names
to something different.

Ideally I don't want to change the paramaters, ie. Select sCol1 As
[Agreement Number] since existing code may already be using the stored
procedure.

Can any on help on how to set these destination column names?

Thanks in advance
AL

Hello Al,

Not too sure as you are going to get much joy from this. One way i can see
to do this is at design time you go to the advanced editor and change the
names of the columns.

You will not be able to do this at runtime as

1. everything will get "metadata unhappy" and will undoubtedly not work.
2. You can modify these types of propty at runtime



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com