Re: Set Excel column names on destination with SSIS pacakge

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

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


.

Relevant Pages

  • Oracle Stored Proc problem
    ... Is there any way to declare a variable in stored procedure that should ... hold --- length of text which is not known at design time. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.server)
  • Oracle Stored Proc issues
    ... Is there any way to declare a variable in stored procedure that should ... hold --- length of text which is not known at design time. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.misc)
  • Re: Any way to keep TADOStoredProc parameters
    ... connect the TADOStroedProc component to the database at design time. ... I only type in the name of the stored procedure into the box. ...
    (borland.public.delphi.database.ado)
  • Re: Oracle Stored Proc problem
    ... hold --- length of text which is not known at design time. ... While executing the stored procedure at runtime, ... PL SQL variables are limited to 32K. ...
    (comp.databases.oracle.server)