Calling Function with parameter using DTS

[VenkatSQL]

Hi Experts

I want to execute function which is going to use as table

like
( In Transform Data task properties - SQl Query as)

select * from testven(?,?)

It shows error message as

Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Syntax error or access violation



Thanks in advance

regards

venkat

 

[AlexCuse]

is testven a user-defined function?

If so, try

select * from [b]dbo.[/b]testven(?,?)

(Assumes your function owner is dbo, and it really should be if its not)

Hope this helps,

Alex

[small]----signature below----[/small]
You can't fit a square data in a round table