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 2005 Forums  SSIS and Import/Export (2005)  Conditional Column in SSIS

Author  Topic  ankita28 Starting Member 1 Post Posted - 2014-02-05 : 03:29:07 Hello, In SSIS I m fetching some records for some date(posting_Date) < user defined date (suppose 2013-04-01). I have to apply the following condition in a derived column : [Posting Date]<=@date ? [Quantity] : 0 The data type for the same is coming as boolean. Please let me know how to convert it to int. Thank You