Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 How to pass partameter for UDF in SSIS

Author  Topic 

Chinni
Yak Posting Veteran

95 Posts

Posted - 2013-07-18 : 19:53:52
Hello ....

How do I pass a parameter to udf in SSIS

i tried
Vaibale Inputvar as string

input to function should be datetime

select select count(*) from dbo.udffunction(?) in execute task

parameter mapping : User::date input date Parameter value =0
result set : Outputrowcount user::outputrowcount

getting errors

"An error occurred while extracting the result into a variable of type (DBTYPE_DATE)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Check for Missing Groups


Thank you

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-19 : 00:48:33
what have you set as value for resultset property? it should be full resultset. You should also give an alias to count value and then map it to a variable created in SSIS if you want to use it forward

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -