ExecSQL Task Truncates Ouput Parameter

I am successfully passing several parameters into a SP using the ExecSQL Task. I have a single parameter that is an OUTPUT parameter in the SP.

I always recieve the first character of the OUTPUT string. I have tried chaning the data type of the parameter mapping [AnsiString, String, etc.] and I have tried changing the data type of the OUTPUT parameter [varchar, char, nvarchar, nchar]

In each case, only the frist character of the output value is returned and subsequently passed to the next SSIS component / task.

Any ideas why this value is truncated?It is a String.

One of the previous replies indicated that there is a max lenght on the variable, but I do not see where to set this length. Any further information on the issue is appreciated.

John|||

jloper wrote:

One of the previous replies indicated that there is a max lenght on the variable, but I do not see where to set this length. Any further information on the issue is appreciated.

John

Ignore that, I was wrong. Sorry!

Note to self: Check out your answers before posting them!

-Jamie

Excel ouput

Hi All,
I have a requirement where I need to create a report book (7 reports) making
use of RS. The challenge is that the client need this in excel. A button on
the intranet must generate the excel output.
Has anyone done something like this as I can't find any docs on RS and excel
output.
1. When generating an excel file from RS does it xls keep formulas
2. Can each sheet be a different report (sheet name must be report name)
3. Limitations'
Any help appreciated!
ThanksExcel isn't a database reporting tool
Tell them to screw themselves.
-Aaron
Dewald wrote:
> Hi All,
> I have a requirement where I need to create a report book (7 reports) making
> use of RS. The challenge is that the client need this in excel. A button on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and excel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> Any help appreciated!
> Thanks|||Hi Dewald,
The known issue I know of is if you have a complex design in RS, in
Excel cells will have been merged and once that is done, the row size
will not want to expand to the appropriate (considering the text in it
would require so.)
Cheers
Dewald a =E9crit :
> Hi All,
> I have a requirement where I need to create a report book (7 reports) mak=ing
> use of RS. The challenge is that the client need this in excel. A button =on
> the intranet must generate the excel output.
> Has anyone done something like this as I can't find any docs on RS and ex=cel
> output.
> 1. When generating an excel file from RS does it xls keep formulas
> 2. Can each sheet be a different report (sheet name must be report name)
> 3. Limitations'
> > Any help appreciated!
> Thanks|||Hi,
Thanks for the reply
Yes,the more complex the look and feel is the less desired output you will
get in XSL.
I have managed to created XSL outputs from a hyperlink in a simple HTML page
that generates a XLS file and add different reports on seperate sheets
If anyone is interested on how to do this let me know...
I also found this site helpfull
http://msdn2.microsoft.com/en-us/library/ms156268.aspx
Thanks for the reply
Cheers
"Sébastien Richer" wrote:
> Hi Dewald,
> The known issue I know of is if you have a complex design in RS, in
> Excel cells will have been merged and once that is done, the row size
> will not want to expand to the appropriate (considering the text in it
> would require so.)
> Cheers
> Dewald a écrit :
> > Hi All,
> >
> > I have a requirement where I need to create a report book (7 reports) making
> > use of RS. The challenge is that the client need this in excel. A button on
> > the intranet must generate the excel output.
> >
> > Has anyone done something like this as I can't find any docs on RS and excel
> > output.
> >
> > 1. When generating an excel file from RS does it xls keep formulas
> > 2. Can each sheet be a different report (sheet name must be report name)
> > 3. Limitations'
> >
> > Any help appreciated!
> > Thanks
>