SSIS Oledb command datetime2 operand clash error by jkmelbs

Active

Type:	Bug
ID:	774693
Opened:	12/18/2012 3:52:26 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Operand clash error when trying to execute a stored procedure that has a datetime2 parameter in an oledb command

Details (expand)

English

SQL Server 2008 R2

Integration Services (DTS)

Not Applicable

--create following sproc
CREATE PROC dbo.datetime2_test
(
@inputdate datetime2(0)
)
AS
BEGIN
SET NOCOUNT ON
RETURN
END

create data flow in ssis. place an oledb command component in the data flow

use the following as the command:

EXEC dbo.datetime2_test ?

attempt to map the columns on the column mappings tab

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Operand type clash: int is incompatible with datetime2".

ability to map a value to the stored procedure parameter

0 attachments

Microsoft