Operand type clash "int is incompatible with date

Question

Operand type clash "int is incompatible with date

komal145

SSCrazy Eights

Points: 9918
More actions
May 29, 2018 at 2:49 pm

#406188

hi ,
I am trying to cretae a packge in 2008 r2 .
My storedprocedure is created something like this:
In Storedprocedure
CREATE PROCEDURE DBO.SP_GET_DataFile_Phase1
@maxlastRunDate date
,@Investor Nvarchar(30)
(
code
)
In 2008r2 package
Oledb Source :
SET FMTONLY OFF;
EXECUTE DBO.SP_GS_GET_DataFile_Phase1 ?, ?
Variables :
Lastrundate : string
investor: string
It keeps thrwoing me error : operand type clash , int is incompatable with date.
What is the solution ? and I don't remember how i fixed last time 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

komal145 - Tuesday, May 29, 2018 2:49 PM
hi ,
I am trying to cretae a packge in 2008 r2 .
My storedprocedure is created something like this:
In Storedprocedure
CREATE PROCEDURE DBO.SP_GET_DataFile_Phase1
@maxlastRunDate date
,@Investor Nvarchar(30)
(
code
)
In 2008r2 package
Oledb Source :
SET FMTONLY OFF;
EXECUTE DBO.SP_GS_GET_DataFile_Phase1 ?, ?
Variables :
Lastrundate : string
investor: string
It keeps thrwoing me error : operand type clash , int is incompatable with date.
What is the solution ? and I don't remember how i fixed last time 🙁

Well, without the code there is no way to tell you what is wrong in the procedure.

komal145 SSCrazy Eights Points: 9918 More actions · Answer 2

Lynn Pettis - Tuesday, May 29, 2018 3:17 PM
komal145 - Tuesday, May 29, 2018 2:49 PM
hi ,
I am trying to cretae a packge in 2008 r2 .
My storedprocedure is created something like this:
In Storedprocedure
CREATE PROCEDURE DBO.SP_GET_DataFile_Phase1
@maxlastRunDate date
,@Investor Nvarchar(30)
(
code
)
In 2008r2 package
Oledb Source :
SET FMTONLY OFF;
EXECUTE DBO.SP_GS_GET_DataFile_Phase1 ?, ?
Variables :
Lastrundate : string
investor: string
It keeps thrwoing me error : operand type clash , int is incompatable with date.
What is the solution ? and I don't remember how i fixed last time 🙁
Well, without the code there is no way to tell you what is wrong in the procedure.

Nver mind...i changed date in storedprocedure to varcahr(10). It works now.