Geek asks and answers

"Statement cannot be prepared" error in SSIS using UDF

I have a data flow task in SSIS '08, with an OLEDB data source. The request is:

SELECT DISTINCT
    dbo.udf_CreateCCISSentenceDuration(probation_year, probation_month, probation_day)
FROM sentence

I just simplified the request to make it more readable. I get the following error:

Error at 11012 DATA [Data Records [27]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E14
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14
Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14
Description: "Cannot find either column "dbo" or the user-defined function or aggreate
"dbo.udf_CreateCCISSentenceDuration", or the name is ambiguous.".

This request works fine in SSMS. If I remove the "dbo". owner, I get the "udf_CreateCCISSentenceDuration" not recognized function built-in name. ". The database in which I perform this operation is an instance of SQL 2005. I performed a search, but cannot find anything related to this error and UDF. Any help is greatly appreciated!

+6
source share
2 answers

, , SSIS. , , SSIS, , . , proc / , oledb.

, 4 , db, owner , , , , (, [myServerWhereFunctionIs]. [myDatabaseInstanceWhereFunctionIs]. [ownerSchemaOfFunction].udf_Function

0

- . . , , .

-1

More articles:


All Articles