dbTalk Databases Forums  

SSIS Custom Component DerivedColumn programmatically problems

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS Custom Component DerivedColumn programmatically problems in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
paganelli.francesco@gmail.com
 
Posts: n/a

Default SSIS Custom Component DerivedColumn programmatically problems - 02-13-2006 , 08:27 AM








dear experts,
i'm trying to build a package programmatically from client c#
application. I'm working to create three dataflow components:
- OleDB Source
- Derived Column Transformations
- OleDb Destination.

My package works good, but i have several problems when insert an
expression as Value of an IDTSCustomPropriety90 object, like this one:
[LEN](#firsname.lineageID) &gt 5 ? <<if true>> : <<if false>>

Simple expressions like concatenate strings, for example
"#firstname.lineageID" + "#lastname.lineageID" seem to work good.

Thanks a lot in advanced.

Paganelli Francesco


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.