Problem using GLobal Variables in DTS Package

Hello,

I use SQL 2K on a Win2K box

I have created a DTS package, the data source is a stored procedure with an
integer for the only parameter like:

exec myproc intparm

When I have a literal for the parm, it runs fine. When I replace the number
with a question mark, I get this message:

No value given for one or more required parameters

I get this message when I try the Preview button, but the Parse Query
returns success.

If I save the package & execute it, it fails and I get the message:

Invalid character value for cast specification

I have created a global variable called FI_ID, set it to be an "INT", and
given it an initial value of "1" (one), without the quotes. I hae assigned
this to the parameter.

The source connection for the transformation uses Microsoft OLE DB Provider
for SQL Server, the destonation is a CSV file, so there is only one
transformation for all of the fields returned by the stored proc.

Any ideas?

Thanks,
Dave

Its a datype problem. Change the datatype of the global variable to integer.
With regards to preview its ok, as the value will be passed at run time.

--Vishal.

"DaveM" wrote:

> Hello,
>
> I use SQL 2K on a Win2K box
>
> I have created a DTS package, the data source is a stored procedure with an
> integer for the only parameter like:
>
> exec myproc intparm
>
> When I have a literal for the parm, it runs fine. When I replace the number
> with a question mark, I get this message:
>
> No value given for one or more required parameters
>
> I get this message when I try the Preview button, but the Parse Query
> returns success.
>
> If I save the package & execute it, it fails and I get the message:
>
> Invalid character value for cast specification
>
> I have created a global variable called FI_ID, set it to be an "INT", and
> given it an initial value of "1" (one), without the quotes. I hae assigned
> this to the parameter.
>
> The source connection for the transformation uses Microsoft OLE DB Provider
> for SQL Server, the destonation is a CSV file, so there is only one
> transformation for all of the fields returned by the stored proc.
>
> Any ideas?
>
> Thanks,
> Dave