"Kayda" wrote:

> Hi:
>
> I am having a lot more problems with data types in SSIS 2005 than in
> DTS.
>
> I have a global variable in an SSIS package which has a datatype, an
> Execture SQL task which has a datatype, and a sproc which has a
> datatype. The global variable is fixed and is just going to hold a
> number of days like 30, no more than a value of 730, and no decima
> places. I've been switching around the datatypes and getting various
> errors when I try to execute. What datatype should I set for:
>
> 1. The global variable
> 2. The task's input parameter
> 3. The stored proc's input parameter
>
> The query in the Execute SQL task is just this:
>
> EXEC dbo.myproc ?
>
> The parameter name I have set as 0 as it is just an OLE connection to
> SQL Server.
>
> Oh yes, is there a separate SSIS2005 newsgroup yet?
>
> Thanks,
> Kayda
>