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.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2013-02-06 : 08:44:31
|
| hii create a packge that transfer date from ole db source to oledb destionation.in ole db source i write simple query "select * from customers"but i have udf that i want to add in select :"select a,f_trn(cust) from customers"which component can i use this function? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-06 : 10:03:42
|
You should be able to use the modified query. Use two-part name for the udf that includes the schema:select a,dbo.f_trn(cust) from customers |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-02-06 : 13:25:51
|
| 1.i want to use simple quey "select * from....) in ole db source2.which component can i use the function (udf) on the some column, (after the ole db source)?thanks |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2013-02-06 : 14:59:18
|
| inbs .. As per James K, all you need to do is modify your query in your ole db source. It is assumed you are using SQL Command as data access mode in the ole db source task.Based on James K ..select *, dbo.f_trn(cust) as newColumnName from customersThe query will give you all columns from the customer table and newColumnName column |
|
|
|
|
|
|
udf (function) in ssis