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 2008 Forums
 SSIS and Import/Export (2008)
 udf (function) in ssis

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2013-02-06 : 08:44:31
hi

i 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
Go to Top of Page

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 source
2.which component can i use the function (udf) on the some column, (after the ole db source)?


thanks
Go to Top of Page

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 customers


The query will give you all columns from the customer table and newColumnName column
Go to Top of Page
   

- Advertisement -