May 29, 2018 at 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 🙁
May 29, 2018 at 3:17 pm
komal145 - Tuesday, May 29, 2018 2:49 PMhi ,
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: stringIt 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.
May 29, 2018 at 3:27 pm
Lynn Pettis - Tuesday, May 29, 2018 3:17 PMkomal145 - Tuesday, May 29, 2018 2:49 PMhi ,
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: stringIt 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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply